Re: Re: UPDATE table problem

I'm tired, lost, or otherwise: your db is set up as:- my create table was this CREATE TABLE(name > varchar(128), passwd varchar(128)); then you run the following query against it: $update_query =3D "update guestbook set last_access=3Dnow() where = guest_id=3D'$result'"; Please explain, =dn ----- Original Message ----- From: "Thomas "omega" Henning" <tomi@mediasoft.ro> To: <php-db@lists.php.net> Sent: 16 October 2001 19:42 Subject: Re: [PHP-DB] Re: UPDATE table problem > affected rows() sed nothing 0 my create table was this CREATE TABLE(name > varchar(128), passwd varchar(128)); > and i need 2 update name and passwd at the same time! and my mysql shel it > went perfectly!!! > > Thomas > > "Rick Emery" <remery@excel.com> wrote in message > > news:EAA093B474ABD311A71E00508B5FE08305C2CAA5@adntex03.us.excel.com...5#ÉäÙ¼FU–t_Z > ¨ > > 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 > > > > > > -- > 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 > >