A short question about date inserting

[Rommeo]

I have the birthdate values sent from a form that are :

day(ex : 31) / month(ex : 12) / year(ex : 1900)

 

and I want to insert it to "bdate(DATE)" column in mysql.

Which function should I use to correct the values for to insert mysql ?

 

insert into people ( .... surname, bdate, gender..... )
values ( .......'$surname', $bdate, '$gender')

[premiso]

If the column they are being entered into is a DATE column you just have to combine them to be in the form of:

 

YYYY-MM-DD

 

And they will go in just fine.

[syed]

just to add to premiso

 

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