This must be a regularly appearing problem, which is why i'm surprised I
can't find a webpage on it..
I have
$result = mysql_query("SELECT title, url, description, author,
date_format(date,'%D %M %Y') AS date FROM documents_tbl, url_tbl WHERE
documents_tbl.title_id = url_tbl.url_id ORDER BY date DESC");
Everything works fine, but the ORDER BY bit sorts all dates as 9th, 8th 7th
etc rather than 31st, 30th and so on.
can anyone tell me where to look to read all about it.
Thanks Jules
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
