creating sub categories?
hello all. I have a table that lists names of categories (i.e., Food Service, Plumbing, Lab Safety).
I have another table called subcategories. This table has names that are tagged to appear in the proper main categories listed above.
The problem is I cant figure out the code to allow a loop through the records and display the correct sub category table to appear under the correct category.
Assuming my tables are set up correctly, how can I just loop the main categories as a list, and then loop all the related sub categories to appear below them?
FOOD SERVICE (Main category)
Commercial Dishwashers (sub category)
Grills (sub category)
Sinks (sub category)
I appreciate a starting direction here. I am using MySQL and .asp