Hope i'm putting this in the right place. Apologies if i'm not!
I'm making a website for a sports suppliments supplier. I'm having some trouble with how to layout the database.
I have a navigation menu which has all the categories listed. But some of my products are listed in multiple categories. I can't figure out how to layout my database.
I have in table products:
Product_ID, Category_ID, Product_Name, Product_Description
And in table categories I have:
How do I go about putting a product into multiple Categories?