RE: [PHP] Order function in SQL

Use the sql keywords DESC - DESCending ASC - ASCending eg select * from tablename order by datefield desc I would recommend that a look at basic SQL is in order for you - some links are: http://www.webdevelopersjournal.com/articles/sql.html http://www.willcam.com/sql/default.htm cheers, Lawrence -----Original Message----- From: Merten Andersson [mailto:martenba@hotmail.com] Sent: December 1, 2000 06:29 PM To: php-general@lists.php.net Subject: [PHP] Order function in SQL PLEEEEESE HELP! :-) If I order by date in SQL the first date thats been added appears first. I need to invert that function so that the last date comes first. Is ther anyone out there how got the answere? Thank you! /Mårten Andersson ____________________________________________________________________________ _________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net