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 chec
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 includ
> 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`, `
