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 insert the date into my table?
the code is running well without errors but y is it that three of the columns in the table do not insert data?
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 delete a row from a table?
How do I find the number of rows in a result set?