I want to be able to add something into multiple categories.
Currently, when I add something to the database, I choose a category, for example: “Red” with the ID of 1
That item then belongs to the Red category.
I have a category page which selects everything for category 1 “Red”.
All red items are displayed on page.
What I want to know is, how to do multiple categories?
What if an item is Red and Blue?
Category 1 - Red and Category 2 - Blue
How do I insert it into the database to be 1,2 and how do I select that item as just 1 for the Red category but then it is also in the Blue category when you look there?
Thanks!
Hope my example was okay :x