I am currently a bit stuck and would like some help. I am designing a product catalogue and need help with multiple categories. The way i have it like this.
CatLevel --> Level Of Category i.e. 0 for top level, 1 for next etc
CatParent --> Category Parent - cat above this cat i.e. if i had a computer mouse and its category was Accesories then the parent of that would be computer equipment, and the parent of that may be all products. its so i can build like a breadcrumb of navigation such as!
All >> Computer Equipment >> Accesories
Is this concept ok, or am i missing something?
I am assuming that i can use this method to do this. if a product is assi