[SOLVED] ignore

[nealo]

Wrong area sorry

[xyn]

I would suggest the following making 3 tables.

1 table for Large shirts.

1 table for medium shirts.

1 table for small shirts.

etc. if you understand?

 

then each table has the following...

id

design_number

color

stock

 

Then you can update the following records by their Size?

[nealo]

So my head is now exploding.

I'm pretty new to this php mysql stuff but have had experience in other scripting languages and I'm trying to learn as i go on. However I've met a dead end. My families business is designing and selling tee-shirts and we have decided to go online.

Now how to explain, the customer will choose a garment --> gender --> design --> colour --> size. The problem arises as we make the shirts once they have been ordered so say the customer chooses

 

shirt --> mens --> design one --> white --> medium

 

this will decrease the stock number of the medium mens white teeshirts by one

 

shirt --> mens --> design two --> white --> medium

 

and this, i want, to decrease the same stock number but i can design the database to do so. The only way i can figure out is to have separate tables for every design and colour but this will mean having the medium mens white tee-shirts numerous times so that each design would have its on individual stock.

 

If you understand, its not been easy to put into words, i am grateful for any help

Nealo

 

 

 

 

 

thanks for the quick reply, just had to draw it out ... say with 3 designs, i would still have the colour repeated 3 times. personally im begining to think it isnt possible.

Nealo