Imploding form input into date for mySQL

[Anon]

i have searched for hours for this, i must be missing a basic principal.

basically, i have set up a form for users to add events listings to our database. to make the form simple for the user, i created separate drop down menus for each of the date, month and year, the form would pass these through as $date, $month and $year.

the problem is trying to transform these three variables into the date entry format handled by mySQL.

for instance:

if $year is 2001
$month is 01
$date is 01

i would like it to form the string in a new variable where $event_date = 2001-01-01.

i have tried imploding, arrays, strtotime, serialise, and some crazy things i made functions for.

ta.

[kparker]

Gosh, can't you just say:

$qry = "insert into xyz (..., date) values (..., $year-$month-$day)";

???

[andyman]

Or.....
concatenate them before insertion i.e.

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

and then do what Kirk said.