Add ORDER BY postdate DESC to the end of the query.
> I'm creating a Blogger-like system for my website and I have it check for
> posts within the last 14 days using the following command:
>
> $result = mysql_query("SELECT * FROM data WHERE TO_DAYS(NOW()) -
> TO_DAYS(postdate) <= 14",$db);
>
> However, in the while loop and the printf's this is going to display it in
> the format of Older to Newer proceeding down the page.
>
> Example:
> Yay
> posted on 2001-05-11
>
> Fun
> posted on 2001-05-12
>
> This is a problem. How would I get it to go in the opposite order...older
> posts are last on list, while newer posts are at the beginning?
---------------------------------------------------------------------
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