Problem with inserting date

[juminoz]

This seems really simple, but I still couldn't figure it out. I set my field to type "Date" with default of "0000-00-00". Then I tried using PHP to insert the current date, but it wouldn't write and stay as "0000-00-00". Here is my code:

$insert = mysql_query("INSERT INTO registration VALUES ('', '$cusid', '$eid', '$sneed', 'date(y-m-d)')", $db);

I also tried to use now() and it didn't work either.

[saraadmin]

I couldn't tell you off the top of my head about PHP/MySQL date format compatibilites, but the code you've given will probably insert the string "date(y-m-d)". (Sorry if this was meant as an abbreviation or something and I've just misunderstood).

[devinemke]

$insert = mysql_query("INSERT INTO registration VALUES ('', '$cusid', '$eid', '$sneed', CURDATE()");