Getting now() date to show up in database

[LynneM]

Usine DreamweaverMX, MySQL, PHPadmin.

 

What is the PHP code that I place the now() in, so that the current date will show up in my DB once a web form has been submitted?

 

My DB field is "submit_date", the type is "DATE". It adds the default 0000-00-00. But in all my tests I still get the "0000-00-00" with every entry.

 

Is there some code I need to place on the page using the now()? I thought that the DB would auto fill in a date on submit?

 

Thanks!

Lynne

[Pidde]

Hi man,

 

Now() will get you a result like: 0000-00-00 00:00:00. Otherwise you could change the column to a datetime.

 

If you want the date only, then use the date() function in PHP.

 

date('Y-m-d')

 

This will return:

2004-01-18