Regarding the following query:
SELECT ID,Author,DATE_FORMAT(EntryDate,'%d %m
%y'),SectionID,Title,Summary,Content FROM articles
ORDER BY EntryDate
DESC LIMIT 10
I'm still new to Mysql so I'm not sure on this but I think the problem is with your ORDER BY field. Since you are using the date format function I think the output will not sort correctly. So I think I would try this:
SELECT ID,Author, DATE_FORMAT(EntryDate,'%d %m %y') FormatedDate, EntryDate, SectionID,Title,Summary,Content FROM articles ORDER BY EntryDate DESC LIMIT 10
Then just don't use the EntryDate column from the query. It's worth a try.
Chris W
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
