Meet my Products table: CREATE TABLE [Products] ( [Product_id] [int] NOT NULL , [Product_title] [varchar] (200) NULL , [Category_id] [int] NOT NULL , )
Each product has a category, meet my categories table: CREATE TABLE [Categories] ( [Category_id] [int] NOT NULL , [Category_parent] [int] NULL , [Category_title] [varchar] (200) NULL , [Category_count] [int] NULL DEFAULT (0) ) As you can see, each category has a Category_parent which symbolize the above category (categories are sorted hirarchly). Can I do some kind of a loop that will run for each Category_id, and store in Category_count the number of Products available in that category, and all of the hirearchy categories beneath? i.e - if I have the following categories: (1) Printers (2) Laser (category_parent=1) (3) Ink (category_parent=1) and the following products: HP LaserJet (category_id = 2) HP Deskjet (category_id = 3) Canon BJ200D (Category_id = 3) category count will be: (1) Printers => 3 (1+2) (2) Laser => 1 (3) Ink => 2 Help!? ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists