Another common query is to get to the current time in addition to the date within 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'");
Leave a Reply.