countries_name"
-Original Message-
From: Boaz Yahav [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 12:13 AM
To: Ralph; PHP General Mailing List
Subject: RE: [PHP] Sorting Country List
Why don't you just add a hard coded line like this:
USA
as the 1st option in your selec
he country table I use stores the Country Code and then the Country Name,
can send the SQL for that if you need it.
Craig
> -Original Message-
> From: Ralph [mailto:[EMAIL PROTECTED]
> Sent: 25 June 2003 06:43
> To: PHP General Mailing List
> Subject: [PHP] Sorting Co
003 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
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
4 matches
Mail list logo
