Ok, I'm trying to complete a shopping site for a design course. The basic problem is this:
On my main product page there are a number of product categories, most of which lead to the list of products, but some categories have sub categories, ie: the kitchen category has crockery, cutlery, glassware etc.
In my database I have a category table and a sub category table but if you click the kitchen link it displays ALL sub categories, which I dont want.
How do I get it to just display the kitchen sub categories. I'm sure this is so simple but my head wont fit around it.
Do i need seperate database tables for each sub category?? I'm sure that isn't the answer cos it seems so long winded but its all my brain will answer at the minute - minly because its fried!