Hi Peter,
The collumn is a datatime... You are tight that date probably should be is a
reserved word..
I must say that I never had any troubles with it, I started using it when I
was a newbie with PHP about a year ago...
On almost all my tables I always have an auto-increment column with the name
First off, I don't think you should use 'date' as a column name; isn't it
a reserved word?
Then, hmm.. is that column a DATE column, or DATETIME, or TIMESTAMP?
If it is DATETIME or TIMESTAMP, then you don't really need the DATE_FORMAT()
conversion; compaing a DATETIME or TIMESTAMP value directly