Insert Date into Mysql? Newbie

[Anon]

Hi, i have a form that inputs into a mysql database. How do i input the date into mysql?

Thanks

Jonno

[fishman4]

Try this:

$insert = mysql_query("Insert into DBNAME (Column1, Column2, Column3) Values (Value1, Value2, Value3)");
if (!$insert)
{
echo("<P>Something went wrong inserting following values: $value1, $value2, $value3 <BR>Error: mysql_error());
exit();
}

[Anon]

hmmmm, nope i have a form, when it is submitted i want it to automatically record the date it was processed.

Anyone know how?

[Anon]

Use
time() to get the current date time
date() to format it for MySQL
mysql_query() to send it to MySQL.

All these functions are documented in the PHP documentation. To see what format MySQL expects the date, check out the MySQL documentation at http://mysql.com/

Diego