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 enters the date) but I want articles
in order of entry - at the moment the oldest article on any particular day
is listed first.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to