I am setting up a website for a friend who started a program to keep medical information in folders where Emergency Workers can find them easily. She has mailed fliers to EMS and Fire agencies throughout several states and they have started confirming receipt of them via an email form on the website. She has expressed the desire to have the form automatically populate the pages where the confirmed agencies will be listed. I have already rebuilt the form so that it will insert the results into the database for us, now I am trying to build the page to display the results. She wants a separate page for each state so I need the query to be specific to a certain field. The form/database collects Agency Names, Address, City, State, Zip, Phone, Email, County Served, etc...

The only results we want displayed on the page is the County Served and Agency Name. I have found some guides on building searches as well as displaying all the results but can anyone offer any advice on how to get the page to only display the results where the field "State" is Missouri and sort those results by the field "County", then only display "County" and "AgencyName"?

Just for reference, I am using PHP and MySQL

I have been stuck on this for a couple of days so any help anyone can offer is greatly appreciated.

You are correct about this being really simple. I have done it before but I was drawing a huge blank this time around and was having problems finding the solution to get it to filter by state then county.

As far as the SQL Injection and medical records, no worries there. This system does not actually contain any medical records of any type. My friend supplies a form that people keep in their car or home in bright envelopes so in case of an emergency, first responders can the victims vital information quickly. The database simply keeps track of what emergency service agencies have been advised of the program.