Displaying 2 results from an estimated 2 matches for "colors_products".
2005 Oct 05
3
Shopping Cart: SKU and Product Confusion
...first, the SKU #''s
provided by the client were not specific to the combination each product
offers. So, the related DB tables were essentially this:
Table Products:
===========
id | sku | title | price | etc...
Table Colors:
=========
id | color
Table Sizes:
=========
id | sizes
Table Colors_Products:
=================
color_id | product_id
Table Products_Sizes:
================
product_id | size_id
Everything was fine and dandy until I got to the point where I wanted each
combination of a product to appear as a separate line item in the shopping
cart (the natural way to display items). There...
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