RE: [PHP] MySQL and sorting
| From: | David Freeman | Date: | Tue, 21 May 2002 04:54:38 +0000 |
| Subject: | RE: [PHP] MySQL and sorting | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-98562@lists.php.net to get a copy of this message | ||
> 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 favourite mysql manual for the
'order by' part, particularly the bit about using 'asc' and 'desc'.
CYA, Dave