query error
Posted: Wed Mar 02, 2005 10:39 pm
i have this error :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/apache/login/clockout.php on line 82
$query = "select * from tbl where userName = '$user' and timeid >= (LAST_UPDATE_ID())";
$result = mysql_query($query);
//while($nt=mysql_fetch_array($result)){
while($nt=mysql_fetch_array($result)){
echo......
when i use LAST_INSERT_ID its ok but it displays all the query, i have to display the last updated row only, anyone can help...
thansk!
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/apache/login/clockout.php on line 82
$query = "select * from tbl where userName = '$user' and timeid >= (LAST_UPDATE_ID())";
$result = mysql_query($query);
//while($nt=mysql_fetch_array($result)){
while($nt=mysql_fetch_array($result)){
echo......
when i use LAST_INSERT_ID its ok but it displays all the query, i have to display the last updated row only, anyone can help...
thansk!