Multiple Values in One MySQL Column?
I have a site with a product table in a MySQL Database. The basic structure, simplified for example, is as follows:
Item Name | Item Description | Color
My problem is, some items have multiple color choices. For example, I might have something similar to the following in my Database:
Item One | This Is Item One | Blue
Item Two | This Is Item Two | Green
Item Three | This Is Item Three | Blue, Purple, Green
Item Four | This Is Item Four | Green, Red
There are several colors that need to be included for items, but I am unsure how to store them. I need the user to be able to select the color from a drop down next to the item, which will then fill in a PHP generated PayPal button.
Any help or advice would be appreciated. Thank you for your time