Code: Select all
$query = "e;UPDATE timein SET timeout='$Today',time2='$time' WHERE userName = '$name' and timeout = '' and timeId >= (LAST_INSERT_ID())"e; or die("e;Couldn't query the user-database."e;);thanks!
Moderator: General Moderators
Code: Select all
$query = "e;UPDATE timein SET timeout='$Today',time2='$time' WHERE userName = '$name' and timeout = '' and timeId >= (LAST_INSERT_ID())"e; or die("e;Couldn't query the user-database."e;);Code: Select all
$query = "UPDATE timein SET timeout='$Today',time2='$time' WHERE userName='$name' AND timeout='' AND timeId=LAST_INSERT_ID()" or die(mysql_error());Code: Select all
UPDATE timein SET timeout='$Today',time2='$time' WHERE userName = '$name' and timeout = '' and timeId = 'MAX(ID)';Code: Select all
$query1 = "e;SELECT MAX(ID) from timein where userName = '$user'"e;;
$idmax = mysql_query($query1);
print $idmax;
$query = "e;UPDATE MAX(timeId) timein SET timeout='$Today',time2='$time' WHERE userName = '$name' and timeout = '' and timeId='$idmax'"e; or die("e;Couldn't query the user-database."e;);
$result = mysql_query($query);Code: Select all
UPDATE
timein
SET
timeout='$today',
time2='$time'
WHERE
userName = '$name' and
timeout = ''
ORDER BY
timeId DESC
LIMIT 1Code: Select all
$query = "e;UPDATE timein SET timeout='$Today',time2='$time' WHERE userName = '$name' and timeout = '' and timeId=SELECT MAX(timeId)"e;;Code: Select all
UPDATE timein SET timeout='$today', time2='$time'WHERE userName = '$name' and timeout = ''ORDER BY timeId DESC LIMIT 1