Here's the situation - I have a dataset that consists of individual tables holding info on 1) specific universities, 2) the campuses of each university, and 3) the programs offered by each campus.
I am trying to retrieve data in such a way as to be able to group the results on a web page by state, and within each state, to display only the campuses in that state.
For some reason I have a mental block here. Right now I make 50 separate calls to the database, one for each state (all the scripting is PHP). I know there is a better way and wish I know more about MySQL... any quick ideas?