I'm trying to insert a date/time code into a mysql database via PHP. I'm trying to insert a date/time in to the database if a date is not submitted via the form. (ie. if $_POST["theDate"] == "", then use the current date). Other than using date() and formatting the date using "y" "m" and "d", is there a way to either set a defualt SQL vault as the current date if nothing is entered, or to have PHP make a time stamp of the current date/time and insert that into the field? Thanks.

well to insert a time stamp just use time() (i think)

You can use mysql itself - to put the current date in just run a query along the lines of:

PHP Code:


mysql_query("INSERT into table (name,tstamp) VALUES ( "Fred", NOW() ) "); 


time(); does some weird time format (UNIX time?) I tried the "NOW()" but realized I also needed to spit the variable out to the page, so I guess I'm using date("Y". "-" . "m" . "-" . "d"); to do it. Thanks for the input.