Sharon, > Do you have a limit to how many levels the category hierarchy can be?
until parent=NULL Thanks! ----- Original Message ----- From: "Sharon Diorio" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 11:48 PM Subject: Re: Meet my tables > > Sharon DiOrio > > ----- Original Message ----- > From: "Jason Davis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, March 19, 2002 3:19 PM > Subject: Meet my tables > > > > 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!? > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
