[PHP] MySQL and sorting

2002-05-20 Thread Cleeker
Is there a way to extract lets say a bunch of dates from a mysql db, and the sort them in order from newest to oldest? Also how would you sort names in alphabetical order? ~Cleeker -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL and sorting

2002-05-20 Thread Miguel Cruz
On Mon, 20 May 2002, Cleeker wrote: Is there a way to extract lets say a bunch of dates from a mysql db, and the sort them in order from newest to oldest? Also how would you sort names in alphabetical order? Read the section of the MySQL manual that covers ORDER BY clauses. miguel -- PHP

Re: [PHP] MySQL and sorting

2002-05-20 Thread Tyler Longren
the 'ASC' with 'DESC'. Tyler Longren Captain Jack Communications www.captainjack.com [EMAIL PROTECTED] - Original Message - From: Cleeker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:11 PM Subject: [PHP] MySQL and sorting Is there a way to extract lets say a bunch

Re: [PHP] MySQL and sorting

2002-05-20 Thread Jason Wong
On Tuesday 21 May 2002 10:11, Cleeker wrote: Is there a way to extract lets say a bunch of dates from a mysql db, and the sort them in order from newest to oldest? Also how would you sort names in alphabetical order? Yes, look at the date/time functions in the (mysql) manual. -- Jason Wong

RE: [PHP] MySQL and sorting

2002-05-20 Thread David Freeman
Is there a way to extract lets say a bunch of dates from a mysql db, and the sort them in order from newest to oldest? Also how would you sort names in alphabetical order? Yes, and a php list is obviously a good place to ask an sql question. In any case, you want to examine your