Thanks Jason, I did think to create the tables like that, but i think I started to lose logic...can I ask, how would the admin for the client be set up. because currently my admin that I have created for existing project consists of a page for creating categories and then a page for creating a product (this includes a select list of the categories that the client would select to assign that category to that product.)
If I use the same method above for this new category system...wouldnt the category select list become quite long once the client adds different sub categories etc..plus the client could possibly get confused to which subcategory belong to which category etc if they are all listed in the same select list.
this is why i did think about assigning the products to what ever category/sub categories on the same pages as creating those categories.
i guess both methods are ok, but which would be more efficient in terms of being better for the client. also if I assign categories/subcategories (in one select list) on the products page, how can I allow the client to add a product to many different categories (if they want to. would it be just a simple case of adding another select list and have another ID field in the products table?
so many ways of doing the same thing, but chosing the right direction at the beginning is what im struggling to decide upon.
So if you can give me your oppinion on the admin side of things that would be great :)