Group by and loop

[Anon]

Hi,

Have anyone know how to handle this issue using PHP? Supposed I want to display data retrieved from database like

Airline United
NorthWest
SouthWest
State CA
NY
CT
MO

When I used \"GROUP BY\", then only display like Airline, State. If I just used \"ORDER BY\", then Airline or State repeat. Either way it is not good. If I want to display data like above, I need to make two queries? if so, how to loop them?

Appreciate your help...

[kparker]

Use the order by for your query. Then, in your loop retrieving the rows, you have to keep track of when the category name changes, and only display it when it changes.