Control Breaks
Posted: Wed Aug 14, 2002 2:03 pm
Does anyone know how to do this?:
I have a mySQL table called "links". I want to query the table and display the results grouped by the type of link with a header for each group. For example:
NEWS SITES
link...
link...
link...
FAN SITES
link...
link...
link...
I understand how to do this sort of thing with COBOL or RPG (gads!) but I'm learning PHP and mySQL so I'm not sure how to do this. I know how to select and group the results, but I can't figure out how to do a single level control break loop to display the output the way I want it.
Can anyone give me some pointers?
-Lloyd Bailey
I have a mySQL table called "links". I want to query the table and display the results grouped by the type of link with a header for each group. For example:
NEWS SITES
link...
link...
link...
FAN SITES
link...
link...
link...
I understand how to do this sort of thing with COBOL or RPG (gads!) but I'm learning PHP and mySQL so I'm not sure how to do this. I know how to select and group the results, but I can't figure out how to do a single level control break loop to display the output the way I want it.
Can anyone give me some pointers?
-Lloyd Bailey