It was quotes around the date format string. Why does the obvious always become obvious only after you ask for help?

I am trying to insert a date into a mysql table field using

<?php
$date=date(Y-m-d);
mysql_query("INSERT INTO table VALUES('$date')");
?>


but when I open up mysql and run SELECT * FROM...