Cant get date from a text field into DB

[Anon]

I just cant figure it out...maybe you can help me.

code looks like this:

HERES THE FIELD

echo "<td width=\"238\" height=\"2\"> ";
				echo "<div align=\"left\">";
					echo "<input type=\"text\" name=\"new_project_due\">";
				echo "</div>";
			echo "</td>";

THE QUERY STRING WHEN PASSED LOOKS LIKE THIS:

dummy.php?new_project_name=www.testpost.com&new_project_owner=Jessamy&new_project_due=2001-05-04&submiter=Add+New+Project

THIS IS THE TEST (obviously) but the others go in correct and $new_project_date gets put in as default 0000-00-00.

if ($submiter=="Add New Project") {
$sql="INSERT INTO web_projects SET ".
"project_name='$new_project_name',".
"project_owner='$new_project_owner'";
"project_due=$new_project_due";

date just wont go in....what am i doing wrong?TIA

[Anon]

you have to quote $new_project_due aswell...

if you'd try:
project_due=2001-05-04 (wich is what actually is the sqlquery)
you'd have sql do:
project_due=1992