[SOLVED] Php update NOW() not updating....

[pneudralics]

Database field for login is timestamp.

Can't seem to update the login time when I click submit. Is the code below correct?

//Update login datetime
$updateloginq = "UPDATE user SET login = \"NOW()\" WHERE email = \"$email\" LIMIT 1";
mysql_query ($updateloginq);

[fry2010]

have you actually already inserted a time into it before hand? Otherwise you cant update. If so try to use CURTIME(). Although that will just be the time not date.

Have you also specified in your table to use datetime, rather than just date.

[Axeia]

You're comparing to the string NOW() since you surrounded it with quotes.

try

//Update login datetime
$updateloginq = "UPDATE user SET login = NOW() WHERE email = \"$email\" LIMIT 1";
mysql_query ($updateloginq);

or better yet,

//Update login datetime
$updateloginq = "UPDATE user SET login = NOW() WHERE email = '$email' LIMIT 1";
mysql_query ($updateloginq);

You're free to use single quotes inside double quotes without escaping them (and vice versa)

[fry2010]

oh yeah...

[pneudralics]

You're comparing to the string NOW() since you surrounded it with quotes.

try

//Update login datetime
$updateloginq = "UPDATE user SET login = NOW() WHERE email = \"$email\" LIMIT 1";
mysql_query ($updateloginq);

or better yet,

//Update login datetime
$updateloginq = "UPDATE user SET login = NOW() WHERE email = '$email' LIMIT 1";
mysql_query ($updateloginq);

You're free to use single quotes inside double quotes without escaping them (and vice versa)

 

Thanks alot!!