How do I access the current time with mysql?
When you want to log when something happens - for instance a post to your message board, this will be a particularly useful thing to know.
With the current time and date you will need to use NOW() like so:
$update = mysql_query("UPDATE my_users SET lastlogin = NOW() WHERE username = 'elvis'");
More mysql PHP QuestionsHow do i list a record in front that is recently added to the table?
How do I set a default value for ENUM fields in PHP?
Why does this code not work? Returns this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ClaimNo = AND UserName = john' at line 2
How do I order the results of my query?
How do I find second highest value from a table?