RE: [PHP-DB] Re: UPDATE table problem

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