easy now() doubt

[pedrobcabral]

SQL query:

ALTER TABLE  `contact` CHANGE  `date`  `date` DATETIME NOT NULL DEFAULT  'now()'

MySQL said:

#1067 - Invalid default value for 'date'

 

I would like to display defaultly the present time, can anyone help me?

[btherl]

Try removing the quotes from now().  The string 'now()' is in invalid format for a date, but the value returned by the function now() will be a date.

[fenway]

You can't default to an expression... just add the column, then run an update... and just use NOW() in your inserts.  I've wanted this feature on DATETIME columns forever, but they won't do it.

[pedrobcabral]

I'm trying to do something like:

$date = now();

And insert on the query to mySQL the variable date, the problem is that is getting me the following error:  Call to undefined function now() - it's the line I've stated above.

 

One more thing, to evaluate if the user has filled the form I'm cheking if some ($_POST[vars]) are set. This part does work but it gives my in my log the following: Use of undefined constant email - assumed 'email' in bla bla bla. Why the hell?

 

Thank you

[fenway]

Sounds like the quoting is wrong, and php is complain that there's no PHP now() function.  As for the post error, I have no idea... not enough info.