Re: Re: UPDATE table problem
| From: | DL Neil | Date: | Tue, 16 Oct 2001 15:57:45 +0000 |
| Subject: | Re: Re: UPDATE table problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13376@lists.php.net to get a copy of this message | ||
You say: "didn't do anything".
What was the response from mysql_affected_rows()?
What is the column description in your CREATE TABLE script?
Is this the only db row that is being updated at this time?
=dn
----- Original Message -----
From: "Rick Emery" <remery@excel.com>
To: "'Thomas "omega" Henning'" <tomi@mediasoft.ro>;
<php-db@lists.php.net>
Sent: 16 October 2001 15:35
Subject: 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
>
>
> --
> 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
>
>