Jump to content

Archived

This topic is now archived and is closed to further replies.

LynneM

Getting now() date to show up in database

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.