Have you tried something like:

$update_query = "UPDATE guestbook SET last_access='$last_access' WHERE

have you tried entering the query manually (e.g. with phpmyAdmin, etc.)
using a relevant guest_id:

UPDATE guestbook SET last_access='NOW()' WHERE guest_id='1'


"Jason Wong" <[EMAIL PROTECTED]> wrote in 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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to