Ray "if" there was a need for a product to belong to many sub categories, then what would I need to prepare for in terms of database structure?
Also for products and categories I am not using the ID column of the database table where possible, as I am using a field in the database that stores the product name or sub category as a link with hyphens so that its SEO friendly and saves me a lot of trouble creating rules in a .HTACCESS file - would you say this is a safe method? From this statement thought I am using the ID column to connect the sub-category table to the product table.
here is some screenshots for context (in the products tables I have included a new top-categories column (not sure if needed though)
and if you look at the categories tables - the column contains "category-location" (which is the top-category) Obviously I guess from this I wouldn't actually need the top-category table since I am telling the website what all the top categories are (but then i wouldn't be able to give top category descriptions and images) What are your thoughts on this approach? I guess I want to find the "best practice" way of doing things rather then just having it work.