Re: [PHP-DB] UPDATE table problem From: Jason Wong (phplist <email protected>)
Date: 10/15/01

On Monday 15 October 2001 21:31 pm, George Lioumis wrote:

> 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'

Where did you get $result from? Looks like you're using it incorrectly.
Could you post more code, particularly the bit which assigns $result.

-- 
Jason Wong
Gremlins Associates
www.gremlins.com.hk

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>