In message <[EMAIL PROTECTED]>, William Watson
<[EMAIL PROTECTED]> writes
>I am trying to create a query to get the results to look like this
>(showing each state only once instead of several times, and list all
>cities underneath their corresponding state, in ascending order):
>
>Example 2:
>
>ALABAMA
>- Huntsville
>- Montgomery
>- Talladega
>
>etc, etc.
>
>I don't have another table that is storing the cities, separate from
>the states. Is this the problem? Can anybody explain to me what I
>need to do to make up a query that will work to output the results
>like I need them? I greatly appreciate any assistance and/or code you
>can provide to help me.
You can't do this by SQL alone - some records would have to return state
names, some would have to return town names.
The simplest way is to SELECT... ORDER BY state, city This would return
all the cities, split up by states.
Then your PHP code would have to read:
$laststate=''
{while more records, read another
if state<>$laststate echo $state; $laststate=State;
echo city
}
--
Pete Clark
Sunny Andalucia
http://www.hotcosta.com/comm_1.htm
