How do I insert the date into my table?
All you need to do is use the built-in CURDATE function, and it works a little like this:
<?php
$q = mysql_query("UPDATE todaysdate SET todayis = CURDATE()");
//sets the field todayis in table todaysdate to 2007-09-18 or whatever the current date is
?>
Comment on this Question and Answer >>>
ASK A QUESTION
More mysql PHP Questions
How do I return the date with mySQL?I am unable to make pages for my search result.Below I am giving the code that I am using. Career Search result Yami says
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 - a
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
How do I access the current time with mysql?
