bullbreed Posted February 17, 2010 Share Posted February 17, 2010 Lets say I have a product (T-Shirt) that has 5 different designs available in 5 colours each design ; e.g. Design 1 - Black - White - Blue - Red - Pink Design 2 - Black - White - Blue - Red - Pink Design 3 - Black - White - Blue - Red - Pink Design 4 - Black - White - Blue - Red - Pink Design 5 - Black - White - Blue - Red - Pink The user will select a design and then the colour and be shown the T-Shirt in the selected colour The default for Design 1 will be Black. Clicking on a Red Colour Square will load the Red T-Shirt in place of the Black T-Shirt How would these products be best inserted in to the database e.g. Should Design 1 have 5 images uploaded to its row in the database Should I have a different table for all the shirt designs and JOIN them Link to comment https://forums.phpfreaks.com/topic/192408-product-colour-structure/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.