adding current date to INSERT?

[frijole]

I am trying to add the date and time of the insert into the db with the other data but everything I try keeps on coming out 000-00-00?

 

Here is my query:

$query = "INSERT INTO videos (embed_html, description, date) VALUES ('$embedHTML', '$description', ??????)";

[DaveLinger]

$query = "INSERT INTO videos (embed_html, description, date) VALUES ('$embedHTML', '$description', NOW())";

[frijole]

thanks.