Re: [PHP-DB] I'm stuck! From: Jason Wong (php-list <email protected>)
Date: 10/15/01

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

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