[RESOLVED] insert into datetime field within mysql

[ajsharp]

hi

having problem when trying to insert the current time into a datetime field called daterecorded within a mysql database . not sure how to change the insert code

$sql="INSERT INTO $tbl_name( customerid , staffid )VALUES( '$customerid' , '$staffid' )";
$result=mysql_query($sql);

Ive looked at various threads which mentioned to use the function NOW() but not sure where to use this . The table already has current timestamp used for a different field.

If anyone could advise would be appreciated Thanks