From: "Phil Clandillon" <[EMAIL PROTECTED]> > I'm using a very simple PHP script with mySQL to load a news feed (url > encoded) into flash. I've got it working but I would like the records to > come out in the opposite order, with the newest one first.
At the end of your SQL query, simply add an ORDER BY [ASC|DESC] clause. In your case, it looks like it'd be: SELECT * FROM news ORDER BY datetime DESC; -- denonymous www.coldcircuit.net http://24.91.199.33 --------------------------------------------------------------------- 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