[SOLVED] Date into Database

[yddib]

I have comments being posted into the database. Is there a way to get today's date into the database automatically?

[dropfaith]

i like to display the date to user before its inserted in case they want to backdate something

and use the code below in the value of  a form

<?php
$today = date("F j, Y");
PRINT "$today";
?>

 

but this might help too

http://www.tizag.com/mysqlTutorial/mysql-date.php

[yddib]

That didn't work. Blank screen!! 

[JasonLewis]

When inserting the comment use MySQL's NOW() function on the field, but make sure it is a DATETIME or DATE type.

 

$query = mysql_query("INSERT INTO comments (date) VALUES (now())") or die(mysql_error());