Hi, I'm in the preliminary mapping out stages of creating a database table for above in PHPmyadmin.
I have 7 categories and the first one (category 1) is a category that I want to use to show ALL products, but I'm not sure whether I have to create a table entry for both the product category number AND the "all" category number (ie 1). This is what I have so far (attached):
Is this the right way to set up the table (i realise i have to do it properly in phpmyadmin -it's just the table setup i'm concerned about) or do I just need one course name with its own category (eg 2 Home Study Environment) and let the search pull all categories to create an "all" result?
Thanks