Welcome to WebmasterWorld Guest from 54.162.139.217

Forum Moderators: open

Message Too Old, No Replies

MySQL question - nested groupings in a query

     
10:37 pm on Aug 7, 2009 (gmt 0)

Junior Member

5+ Year Member

joined:Aug 27, 2008
posts: 65
votes: 0


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?

Thanks,
Joe

11:58 pm on Aug 7, 2009 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5681
votes: 79


Can you post the code you have so far? It should be a matter of just grabbing all the data to display with SQL, then parsing it correctly in PHP.
3:44 pm on Sept 24, 2009 (gmt 0)

New User

5+ Year Member

joined:Sept 24, 2009
posts:4
votes: 0


you have 3 tables but in which is the state info?
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members