p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Professional (http://p2p.wrox.com/forumdisplay.php?f=63)
-   -   creating sub categories? (http://p2p.wrox.com/showthread.php?t=75571)

melkin August 5th, 2009 12:23 PM

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?

ie,

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

J_P August 30th, 2009 11:17 AM

use nested loops


All times are GMT -4. The time now is 06:30 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.