How do I access the current time with mysql?

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:

<?php 
$update = mysql_query("UPDATE my_users SET lastlogin = NOW() WHERE username = 'elvis'"); 
?>