In my database, I have a Categories table. Categories can have parent categories, making it a recursive relationship
I also have a products table. Each product falls under a category.
Say, for example, I have a tree that looks like this:
Category
Sub-Category 1
Sub-Sub-Category 1
Product 1
Product 2
Product 3
Product 4
Sub-Sub-Category 2
Product 5
Product 6
Product 7
Product 8
Sub-Category 2
Sub-Sub-Category 3
Product 9
Product 10
Product 11
Product 12
If I do $SubCategory1->products
, I want it to give me Products 1-8
If I do $SubSubCategory3->products
, I want it to give me products 9-12
If I do $Category->products
, I want it to give me all products
Basically, I want the category to give all products that fall under it
Store
a category too? - Doom5