Sorting Country List
| From: | Ralph | Date: | Wed, 25 Jun 2003 04:43:19 +0000 |
| Subject: | Sorting Country List | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-152701@lists.php.net to get a copy of this message | ||
I am getting a list of all countries from mysql database, and then I am
sorting by country name. However since most orders will be from US I
want the US to appear first over the rest of the countries. How can I go
about doing this?
Currently, this is my query:
SELECT countries_id, countries_name FROM TABLE_COUNTRIES ORDER BY
countries_name;