On Monday 17 February 2003 21:06, Ken Goff wrote:
I have encountered what appears to be a bug in MySQL regarding ORDER
BY related to a date field when also used in conjunction with
DATE_FORMAT() or UNIX_TIMESTAMP(). When these functions are applied
to my date field, MySQL ignores any included
I'm glad you found the problem! Sorry my suggestion did not work. I'm still
confused on why you have quotes around the field names in the order by part
of the query, though.
All the best!
-steve-
-
Before posting, please
SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50;
I'm surprised you happened to get anything in order. Maybe the message got
simplified by the list manager, but did you really mean to order by a
constant string?
Why not:
SELECT * FROM EventList ORDER BY `EventDate`,
Heikki Tuuri [EMAIL PROTECTED],
Do you think the following links may help?
* http://www.mysql.com/doc/en/DESCRIBE.html
* http://www.mysql.com/doc/en/ALTER_TABLE.html
* http://www.mysql.com/doc/en/Group_by_functions.html
*