Hallo,
Klar, denn unbechtet der anderen Fehler ist "date" ein Schküsselwort in MySQL http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
sicher? Ich lese (MySQL permits some keywords to be used as unquoted identifiers because many people previously used them.) da was anderes.
Gruß Kalk