Re: Re: UPDATE table problem

I'm using something else made by me! Thomas "Rick Emery" <remery@excel.com> wrote in message news:EAA093B474ABD311A71E00508B5FE08305C2CAA5@adntex03.us.excel.com... > Are you using George's code? Or something different? > > -----Original Message----- > From: Thomas "omega" Henning [mailto:tomi@mediasoft.ro] > Sent: Tuesday, October 16, 2001 7:19 AM > To: php-db@lists.php.net > Subject: [PHP-DB] Re: UPDATE table problem > > > 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 > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >