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:
<?php
$update = mysql_query("UPDATE my_users SET lastlogin = NOW() WHERE username = 'elvis'");
?>
Comment on this Question and Answer >>>
ASK A QUESTION
More mysql PHP Questions
Why will this statement not print a column with "lastname space firstname"? Print " .$info['businessname'] "; Print " .$info['firstname']. " " .$info['lastname'] "; I want to see 2 columns - aI am unable to make pages for my search result.Below I am giving the code that I am using. Career Search result Yami says
How do I find second highest value from a table?
My website www.quicheandpie.com has navigation buttons which were added by going to admin/categorylist and adding a category. I can add category = navigation buttons and update them, but I can not delete them. Any ideas how I can find where the info
What is difference between mysql_fetch_array and mysql_fetch_object?
