i need help!!! updating timestamps

[maxsslade]

I have a stupid problem and the answer is probably so simple.

I am trying to update a mysql database with the current timestamp. Here is the code i have so far:

  $query3 = "UPDATE users SET VALUES last_access = 'now()' WHERE id_user = '$uid'";

Please help, i am stuck

• Max Slade

[amansabharwal]

try this one

$query3 = "UPDATE users SET VALUES last_access = CURRENT_TIMESTAMP WHERE id_user = '$uid'";

[KoshNaranek]

Are you using mysql?

Just create a field type "timestamp" default "now()" .... this field automaticly updates itself every time, the record is changed.

[maxsslade]

i got it working eventually, i used null without the single quotes.

Thanks for your help guys.

• Max