compphenom
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
DB newb ?
in MySQL Help
Posted
I have a question with regards to a database\'s structure. I am not all that proficient with databases, but have managed to get into a situation where I am building a website in PHP and now need to connect to a database.
I have a table with productId, productName, productTitle, productDescription, productPrice, etc. The problem I am running into is that each product comes in any one of 16 colors, however not all. Product A may come in 12 colors while product B might come in all 16 colors and product C comes in only 6 colors. I am trying to dynamically fill a list box with each product\'s available colors, but I do not know the database structure to accomplish this.
Any comments welcome, I hope I have explained this adequately.
- Kevin