Ian ORourke said: > I want to order my articles in descending order on date, and for > articles on the same date I want to order by ID in ASC. I've tried > the following: > > ORDER BY EntryDate DESC, ID ASC > > But it does the EntryDate Order but nothing else.
http://www.catb.org/~esr/faqs/smart-questions.html#id2854194 > The problem I have > is I don't want to record the time (the user enters the date) but I > want articles in order of entry - at the moment the oldest article > on any particular day is listed first. You probably want to use: ORDER BY CAST(EntryDate AS DATE) DESC, ID ASC Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]