August 26th, 2000, 05:38 PM
i'm modifying an existing bbs and i want to get the post to be ordered in a descending order ( i want the newset post to be first). The query is ...
$sql2="select count(*) as count, max(date_format(fd_date,'%m-%d-%Y %H:%i') ) as max_date from forum_data where ftp_id=$ftp_id";
...i've tried adding ORDER BY max_date DESC to the end of the query but it doesn't work. can anyone help me?
thanks in advance!
August 26th, 2000, 06:49 PM
try order by fd_date desc instead because the formated date (max_date) might not sort correctly.