How to properly insert a date

[strangebeer]

I've got a DB of records for upcoming events. Right now, I've done the date as 3 enum columns: $year, $month, $day. The submission form inserts these from 3 drop down menus. I need to be able to start making comparisons for dates by chronology instead of number amount, so I have to start inserting them as dates. The problem is, I don't know the proper syntax or method of doing so. I inserted a new column in the DB with a DATE type (0000-00-00) and in the submission action I added the following into my insert statement:

'".date("Y-m-d","$year"-"$month"-"$day")."'

This inserts a value into the date column, but it's 1969-12-31. Can anyone toss me a bone?

[eoghain]

Don't convert your numbers into a date in PHP before submitting them. You database is expecting 2003-02-28 so send that. You don't have to do anything but format the text properly.

[strangebeer]

Ahh, it worked wonderfully. Thank you.

Now to display events for only today and in the future, would this work?

$today = date("Y-m-d");
"select * from table where showdate >= $today"