UPDATE table problem
| From: | George Lioumis | Date: | Mon, 15 Oct 2001 13:31:20 +0000 |
| Subject: | UPDATE table problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13328@lists.php.net to get a copy of this message | ||
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