How to Organize a PHP/MySQL List by State

[1219]

I have a list here in static HTML.

 

http://www.donjo.net/where_to_buy.html

 

I have worked on being able to insert store, address, state, URL, phone into a database, however, I am having problems organizing it so that it seperates the stores in the database by State and listing them as in the static version.

 

Thanks

 

Adam

[IsmAvatar]

Have you tried ORDER BY?

[1219]

I have setup a temp page here:

 

http://www.donjo.net/test/

 

I am using:

 

SELECT * FROM storeRetailers GROUP BY state ORDER BY state ASC

 

But in the html body it now only shows one store per state instead of them all. Is something wrong with the HTML ia have for state and displaying the address/retailer.

[IsmAvatar]

remove the Group By. That's what's killing the results. The Order By will automatically group them, simply because 1 and 1 appear between 0 and 2 :-)

[1219]

But i want the states to show only once per.

 

So if Alabama has 3 stores, I only want Alabama listed once.

[1219]

Similar to how this site lists its stores:

 

http://www.innerasiarugs.com/storelocator/print.php