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