RE: [PHP] Sorting Country List
| From: | Boaz Yahav | Date: | Wed, 25 Jun 2003 07:13:06 +0000 |
| Subject: | RE: [PHP] Sorting Country List | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-152708@lists.php.net to get a copy of this message | ||
Why don't you just add a hard coded line like this:
<OPTION VALUE="USA">USA</OPTION>
as the 1st option in your select box?
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
-----Original Message-----
From: Ralph [mailto:ralph@nqionline.com]
Sent: Wednesday, June 25, 2003 6:43 AM
To: PHP General Mailing List
Subject: [PHP] Sorting Country List
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;
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php