Need Help With Date

[Anon]

In my database I have a table that has a dateRegistered field that is a date field.

I want to insert today's date into that field. I am trying to do it this way and get a parse error.

$date = date("m/d/Y");

INSERT INTO m (dateRegistered) VALUES ($date);

Can someone please help??

Thanks,

Webguy

[dolphinsnot]

http://www.php.net/manual/en/function.date.php

-dolphinsnot

[Anon]

VALUES ('$date')

[Anon]

$date = date("Y-m-d");
$sql = "INSERT INTO m (dateRegistered) VALUES ('$date')";
+connection,query,etc..