Re: I'm stuck!
| From: | Jason Wong | Date: | Mon, 15 Oct 2001 11:57:01 +0000 |
| Subject: | Re: I'm stuck! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13322@lists.php.net to get a copy of this message | ||
On Monday 15 October 2001 19:35 pm, you wrote:
> $update_query = "UPDATE guestbook SET last_access='NOW()' WHERE
> guest_id='$guest_id'"; <-----This thing refuses to play!
> Can anyone, please, tell me why the above code doesn't do the update
> in the DB (mySQL)???
try: NOW() without the quotes.
$update_query = "UPDATE guestbook SET last_access=NOW()
WHERE guest_id='$guest_id'";
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk