Re: Multiple Order By

2004-01-25 Thread Jochem van Dieten
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-q

Multiple Order By

2004-01-25 Thread Ian O'Rourke
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. The problem I have is I don't want to record the time (the user ente