[mv] different items, different colours

[cclient@penguin.ecoast.ca]

******    message to minivend-users from cclient@penguin.ecoast.ca     ******


If I have one item and it has about 15 colours and another item 
that has a different list of colours how can I represent this
in terms of both mysql and CommonAdjust?  If I keep making 
new columns in the pricing table for each new colour, that
database becomes pretty unmanageable.

I wondered about using something like ==color:pricing:color so that
I could reference a specific column in the database but for that
to work, it seems like I would need to be able to enter a 
data like:  red=+5%, blue=1.50, green=2.00.  Same thing
goes for size.  

Can I do this?   Does anyone have any other ideas?

Thanks,
Derek Billingsley
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list