DB output display question ...

[Anon]

<longpost>
I have a database with following design (simplified for explanation)

tblCategory
CAT_ID
CAT

tblSUB_CAT
SUB_CAT_ID
SUB_CAT

tblSECTION
SECTION_ID
SECTION

tblCAT_SUBCAT_SECTION
CAT_SUBCAT_SECTION_ID
CAT_ID
SUB_CAT_ID
SECTION_ID

I need to display a webpage that resembles the following:

Category \ SubCategory

• Section 1
  Info 1
  Info 2

• Section 2
  Info 3
  Info 4

What is the best way to create the "grouped report" style output?

• Do a select with Cat and Subcat building an array of all the "sections" associated with the cat/subcat pair, then exec a <new db cursor> using the cat/subcat/section <close cursor> next, etc, etc until done with sections?

• Is there some simpler solution that I am not seeing?

Thanks in advance for the help,

Kind Regards,
-Dan

</longpost>

[Anon]

Hi,

I'm searching for the same answer.
Sorry I don't have it yet :-)
I'd like to output something like :

zip code
customer
customer
zip code
customer
customer
customer

I've done this in coldfusion before. They use a 'group' attribute around the loop.
I was looking at maybe building and array of arrays but even then
I'm not sure how to create an array named one of the zip codes.
Hmmm.
I'd let you know how I got.
Any one else got any answers ?

Thanks
Regards
Rudi.