Category - Subcategory

  • Dear All,

    I am doing a auction project and my requirement is

    I need to show the Main category along with total count of products in it and its subcategories...

    Electrical & Households (11)
     

         Kitchen(5) Dining(6)

     

    In the above out put the Electrical & Household is the main category and Kitchen(5) Dining(6) are  subcategories..

    My table is

    tbl_cat

    cid    Numeric  Identity

    Parent  Numeric 

    Cat_Name  Varchar(100)

     

    tbl_Procucts

    pid  Numeric  Identity

    Cat_Id   Numeric        (foreign key of tbl_cat)

    Prod_Name   Varchar(100)

     

    For clear idea pls visit http://www.erealdeal.com

    Pls assist me ...

    Thanks

    Bala

     

     

     

  • Hello

    Anyone came across this kind of queries

    Regds

    Bala

  • I don't think this this site have moderators...atleast u guys respond for the post...

    Anyways...

    Bye

    Bala

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply