Date is buggy?

Databases
1

I have a mysql table which holds the date (data type is date)
Here’s what I get when I print the insert statement
INSERT INTO reviews (‘2’, ‘2’, ‘2’, ‘2’, ‘2’, ‘2’, ‘2’, ‘3’, ‘2’, ‘2’, ‘2’, ‘2’, ‘3’, ‘2’, ‘3’, ‘2’, ‘2’, ‘2’, ‘0’, ‘2’, ‘2’, ‘2’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’,’ 1’, ‘2’, ‘1’, ‘2’, ‘0’, ‘0’, ‘1’, ‘1’, ‘1’, ‘2’, ‘1’, ‘1’, ‘1’, ‘eeeeeeeeeeeeee’, ‘eeeeeeeeeeeeeeeeeee’, ‘2011-28-09’, ‘eeeeeeeeeeee’, ‘eeeeeeeeee’, ‘eeeeeeeeeeeeeeee’ )
Everything seems to be inserted into the database, but the date is 0000-00-00??
What am I missing

Thanks

2

‘2011-28-09’ is an invalid date

you prolly meant to write ‘2011-09-28’

3

thx