[RESOLVED] DB Design help

[NZ_Kiwis]

I have a new project to make an online store; I’ve done this before and understand the basic concept. My Database will have several tables

Products:
ProductID
ProductName
ProductDesc
ProductPrice

This works well and I have used this before, I need to add these products into “Categories” and “Sub Categories” – maybe even “Sub-Sub Categories”. How would I design my database for this?

My admin page will be able to create a Category, it may be able to create another category inside that Category. So the product “MyCar” can be found under category “Cars” as well as sub category “Blue Cars” and even if added late – “Moden Blue Cars”

[Weedpacket]

You might find something by searching the forums for terms like "database subcategories"; if you know the word "hierarchical" you could use that, too.

[NZ_Kiwis]

Simple, Thanks!