Re: UPDATE table problem
| From: | Jason Wong | Date: | Mon, 15 Oct 2001 15:14:35 +0000 |
| Subject: | Re: UPDATE table problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13336@lists.php.net to get a copy of this message | ||
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