Jump to content

Product colour structure


bullbreed

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

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.