mySQL tables
With the .zip file that I included (hope it turns out okay), I am trying to show what I am trying to do. I have a table set up for the products (which includes all the details). As the document shows, each product will fall into a main category, which further falls into a subcategory.
I have very little (almost none) experience with mySQL and myPHPAdmin (I am learing). Here is my understanding: I should set up a table for products and table for the main categories. Then I need to set up a table for the subcategories (a table for each main category). I should include the category and subcategory as columns in the products table.
Now how to link them? Each of the tables (category and subcategory) should have a ID column and the type column (gps, avionics, etc.). The ID column should be linked to product table as a foreign key. How to do set up the linkage and does mySQL save it automatically? I tried several times and it doesn't seem to save.
Am I going in the right direction? I want the site visitor to be able to search for products by the following way. From a drop down menu, choose a category (such as GPS), then choose a subcategory (such as Panel-mounted) from another drop down menu. Depending on what main category is chosen, the correct subcategory would be appropiated. Is this possible with Data Assist?
I know that this is a lot, but I am learning. You guys thus far have been very helpful. My knowledge in mySQL and myPHPadmin is very weak. Again, thanks for your help.