<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>
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>