Welcome to the Treehouse Community
Looking to learn something new?
How to set Colors, Sizes for a product using PHP & MySql?
I'm creating an e-commerce website and will have different kind of products such as shoes, clothes e.t.c. I'd like for example if someone searches for a shoe, it displays the different Sizes and Colors available for that shoe, and the same goes for clothes or other products needing sizes or colors.
I am stuck in this area, i don't know how to implement this feature for my products. i know there is something to do with joining tables in mySql to have relationships but i can't seem to grasp it.
Anyone can help me or have other ideas how to tackle this problem?