help storing dat of birth

[MDanz]

how do i store date of birth into mysql.  I have mysql field type as DATE.

 

I tried this but not working..

 

$date = $yearOfBirth.'-'.$monthOfBirth.'-'.$dateOfBirth;

$prof = "INSERT INTO Profile";
      $prof .= "(`username`,`location`,`gender`,`dateofbirth`,`information`) VALUES ('$username','$location','$gender',$date,'$about')";
$profresults = mysql_query($prof)or die (mysql_error());

 

the date shows as 0000-00-00

[PFMaBiSmAd]

Literal date values must be enclosed in single-quotes inside the query, otherwise they look like a mathematical expression (2010 - 08 - 02 equals 2000).