Re: UPDATE table problem
| From: | Thomas \"omega\" Henning | Date: | Tue, 16 Oct 2001 12:19:26 +0000 |
| Subject: | Re: UPDATE table problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13362@lists.php.net to get a copy of this message | ||
This puts up my question!!
When i tryed to update my table from my program it didn't do anything no
error nothing. When i tryed the same code in the mysql shell it worked
perfectly
Any idias why??
Thomas
"George Lioumis" <glioumis@adacom.com> wrote in message
news:009a01c1557d$ad29b830$05041fac@adacom.com...
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