In message <[EMAIL PROTECTED]>, cdg1111us <[EMAIL PROTECTED]> writes >Another way to do this would be to query MySQL initially just for the >valid states in whatever order needed, print that state name, then do >another query to find all cities within that state. HTH!
But you just did about 51 queries - one for the states, and one for each of the towns within those states - and my answer was 1 query! > > > > > >--- In [email protected], Pete <[EMAIL PROTECTED]> wrote: >> >> 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 >> > > > > >The php_mysql group is dedicated to learn more about the PHP/MySQL web >database >possibilities through group learning. >Yahoo! Groups Links > > > -- Pete Clark Sunny Andalucia http://www.hotcosta.com/comm_1.htm
