Displaying 1 result from an estimated 1 matches for "orco".
Did you mean:
orc
2007 Jan 08
3
Relating Tables
I have 2 mysql tables, Product and Color:
Color
ID ColorName
1 Red
2 Green
3 Yellow
4 Blue
Products
ID Color1 Color2 Color3 ProductName
1 ? ? ? Orco
2 ? ? ? Skeletor
3 ? ? ? He-Man
I need to display the ColorName to web visitors when they view
Products.
I can do a number of things:
1) put Color.ID into Product.Color1, Product.Color2 and Product.Color3.
These...