[SOLVED] Current DATETIME help

[ReeceSayer]

hi i need to know how to add the current date & time into my mysql table when i send information in a form using php... basically when i send my form i want it to record datetime also...

i have a table named "datetime", using the DATETIME type

 

Thanks

[gevans]

<?php
$query ="INSERT INTO `your-table` VALUES ('your-values', NOW())";
mysql_query($query) or die("Error: ".mysql_error());

 

NOW() should go into your datetime field

[Ken2k7]

You can have MySQL do it by setting the DEFAULT value of the column to CURRENT_TIMESTAMP.

[ReeceSayer]

Problem solved... thanks guys