Basic Report output i can't get my head around

[eluser]TornUp[/eluser]
Hi All!

Going to sound really n00b like and ask for some help in a query/output I'm trying to-do.

im currently producing an electronic phone list in CI, all users are stored in a tables with the following layout:

Users

Code:

id
Name
PhoneExt
DirectDial
Location (links to location->id)

Location:

Code:

id
Title

Now what I am trying to achieve is the following:


New York:
John Smith
Fred Jones
Katie bing

London:
Emma flop
Andy Flip

and so on, and so on....

can someone help me getting my head around the MySql query/passing it to the view via the controller.

I see it done all the time, but the concept confuses me!

Many Thanks

Tom Kirby.