Need help in generating a date when submitting a form

[glady]

Hi,

I have created a form in which data collected will be stored in MySQL, and I wanted to add a field 'date' in the database which reflect the date the form is submitted. Can anyone advise me how to do that? Do I need to create a variable with PHP in the page and then pass it on to MySQL, or if there is an automatic date generating function inside MySQL itself?

Thanks in advance for help.

Cloudy

[af11k]

from the php manual, getdate function...

*-------------------------
mdchaney at michaelchaney dot com
20-Mar-2000 10:49

Inserting date/time values into MySQL does NOT require 10 lines of code for
each date. Just use the "date" function here in PHP to make a MySQL-friendly
field:

$startdate=date('Y-m-d');

Use the optional second argument to specify the time (other than "now")
to be inserted. If you want to insert
into a date/time field, use the
following:

$enddatetime=date('Y-m-d H:i:s');

Again, use the second argument to specify an exact time.
*-------------------------------------
Hope this helps

[xblue]

mysql has functions for the current time built in.

search for NOW() and CURDATE() here:
http://www.mysql.com/doc/en/Date_and_time_functions.html

[Blob]

My favourite date is:

$date = date("d/m/Y H:i");

Assuming you put your database info into variables before connecting, just set this one at the same time. 🙂
Today is the 19th of April, 2003, and right now it's about 2 pm... So it'd make:

19/04/2003 14:00