cannot store this date in mysql table

[kkshansid]

i hav a dropdown list of date 1-31
month january-december
year 2001-2009
i want to save it in musql database with dob field datatype date

$month=$_POST['month'];
$date=$_POST['date'];
$year=$_POST['year'];
$dob="$year/$month/$date";
i want to store this date in mysql table but it doesnt work date still remain 0000-00-00
insert into emp (dob) values('$dob')

[Dheeraj Joshi]

Whether data type of key is varchar(size) or date in your database?

[kkshansid]

Whether data type of key is varchar(size) or date in your database?

its date and field name is dob

[gregerly]

Try

$dob = $year. '-' . $month . '-' . $day;

Greg

[kkshansid]

Try

$dob = $year. '-' . $month . '-' . $day;

Greg

no even it doesnt work

[kkshansid]

it happened i changed it from january-dec to 1-12

[vinothPHP]

you change your data type in your table.., ie., VARCHAR(100)...

[vinothPHP]

you changed this $dob="$year/$month/$date"; to
$dob=$year."-".$month."-".$date";.. ..
now you store $dob it will be worked...