temporary soln for the earlier one BUT>>>>>&g

[sansoft]

Hi,

this was developed from my side.........but does not update the next day the user comes...plz i want to let it update the outitme field the next day!!!

Any suggesstions?????????

Code: Select all



$now = time();

$anh = $date = date("Y-m-d H:i:s a",$now);

//$today=date("F j, Y, g:i a");
$sql23="select outtime from taskdatetime where user_id='$sesuserid'";
$result23=mysql_query($sql23,$conn);
$row=mysql_fetch_object($result23);

if($row->outtime=="")
{

$sql="update taskdatetime set outtime='$anh' where user_id='$sesuserid'" ;

$result=mysql_query($sql,$conn);
}
else
{
$rt="Logout has already been registered.Cannot update the field.";
}

[gesf]

First:
Choose one of those:

Code: Select all

<?php
// This
$anh = date("Y-m-d H:i:s a",$now);

// Or this
$date = date("Y-m-d H:i:s a",$now);

// And not
$anh = $date = date("Y-m-d H:i:s a",$now);
?>

Second:
What´s your outtime field type !? DATETIME/TIMESTAMP !?
You can use MySQL for that. See this: MySQL Date And Time Functions

[sansoft]

Hi gesf,



oh...yes the $anh=$date was a silly mistake....please ignore!!

my outtime field is a datetime type.Please help!!

[WiZARD]

Hi gesf,



oh...yes the $anh=$date was a silly mistake....please ignore!!

my outtime field is a datetime type.Please help!!

some where in code:

Code: Select all

$start_time = "00:00";
$end_time  = "00:05";
$curr_date  = date("H:i",$now);

if ($start_time < $curr_date < $end_time) and ($check==false)
{
$check = true;
.....
update database

}

somthing like that.....

[sansoft]

hi,

the problem is solved ...using the same if statement but in a modified manner.Thank u ver much :grin:

[sansoft]

hi,

the problem is solved ...using the same if statement but in a modified manner.Thank u ver much :grin:

[WiZARD]

hi,

the problem is solved ...using the same if statement but in a modified manner.Thank u ver much :grin:

Welcom, but what for wrote about it twise? :-o