Hi all!
Ok, I'm trying to complete a shopping site for a design course. The basic problem (appart from the fact that I'm completely new at this) 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.
My database tables are like this:
Main categories table: (Categories)
CategoryID, Category, Pic
Sub Categories table: (Categories2)
Category2ID, Category2, Pic2
But in my code, if you click the kitchen link for example, it displays All the sub categories - not just the kitchen ones.
How do I get it to just display the sub categories that I need? I'm sure this is simple but I can't get my head to fit around it.
Please help!
Oh...and please explain it to me like I'm five years old...my brain is screwed!
