I am trying to insert the current date into mysql when a user submits their info. I cant use timestamp for this one. I am using datetime. It works when a user updates but not for creating. I get all 0's in the date column.
Here is the code for the date part only.
$insertSQL = sprintf("INSERT INTO user (date) VALUES (%s)" GetSQLValueString($_POST['date'], "defined", GetSQLValueString($_POST['date'],"date"),'NOW()')); <input name="date" type="hidden" id="date" value="NOW()" />