autodate inserting

[Rother2005]

is it poss to get todays date to be inserted into a field on the database when a user presses submit e.g. makes a order so details need to go into the database about the order and then a date is inculded?

[Jessica]

NOW() is the command for mysql current time on a DATE or DATETIME. Or you could use time() in php if the fieldtype is an INT

[Rother2005]

so then for example

[code]
if(!$_POST['register']){FORM}

else{

$sql = "INSERT INTO member(date)
VALUES ('now()')";
mysql_query($sql)             

or die(mysql_error());
echo ("<meta http-equiv=\"Refresh\" content=\"2; URL=members.php\"/>Thank You! You will be redirected");}

[/code]

is that on the right track?