I was thinking something similar, but I couldn't figure out what it meant (was it in German?).
Why would you need quantity as a field? If buying two, you get a 10% discount, why not put that in a formula? Would make it a little more dynamic. Without knowing all the information: (id, item_name, price, option, option_cost, quantity_discount) ? -- William Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732 | Wireless E-mail: [EMAIL PROTECTED] ----- Original Message ----- From: "Hugh Bothwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 06, 2002 10:00 AM Subject: Re: [PHP-DB] Is this possible? > It looks to me like you should be dividing the data differently; something > like > > (quantity, item, option, price) > VALUES > (1, '6inch', '', '29), > (1, '6inch', 'meny', 51), > (1, 'footlong', '', 45), > (1, 'footlong', 'meny', 66), > > and so forth... > > > "Raymond lilleødegård" <[EMAIL PROTECTED]> wrote in message > 001d01c1af34$621b96e0$31c7d450@amd">news:001d01c1af34$621b96e0$31c7d450@amd... > > My table look like this: > > > > Pricetable: (varetabell) > > -------------------- > > (varenr, type, pris) > > VALUES > > (1, '6inch', 29), > > (1, '6inch meny', 51), > > (1, 'footlong', 45), > > (1, 'footlong meny', 66), > > (1, 'salat', 39), > > (1, 'salat meny', 51), > > (2, '6inch', 49), > > (2, '6inch meny', 69), > > (2, 'footlong', 75), > > (2, 'footlong meny', 96), > > (2, 'salat', 49), > > (2, 'salat meny', 69), > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php