[PHP-DB] UPDATE table problem From: George Lioumis (glioumis <email protected>)
Date: 10/15/01

Hi, everyone, again,

Consider the following piece of code:
-------------------------
$update_query =3D "update guestbook set last_access=3Dnow() where =
guest_id=3D'$result'";
 $update_query =3D stripslashes($update_query);
 echo $update_query;
 echo "<BR><BR>";
 $updated =3D mysql_query($update_query) or die(mysql_error());
if ($updated)
  {
.............etc etc
  }
--------------------------
When ran, it returns:
update guestbook set last_access=3Dnow() where guest_id=3D'Resource =
id#2'

The problem is that if($updated) returns TRUE, but the last_access field =
is not updated at all !!! :(((
Any ideas as far as the $update_query is concerned???

George