Simple question: passing current date to mysql

[asunwatcher]

Hi there,

 

I've just started learning php and mysql today. I'm putting things together in dreamweaver and everything is running smoothly (ish).

 

I've got a form written in php that sends data to a database. All fine.

 

I need to send the time of submission to the database. I've put in a hidden field, what code should I use to set the field value to a mysql field of type DATETIME?

 

Cheers.

[requinix]

Unless your web server and database server are in different timezones, use NOW(). It's a MySQL function, not a PHP function.

INSERT INTO table (fields...) VALUES (..., NOW(), ...)