Re: Is this possible?

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 - wfong@mookandblanchard.com Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732 | Wireless E-mail: 8054907732@mobile.att.net ----- Original Message ----- From: "Hugh Bothwell" <hugh_bothwell@hotmail.com> To: <php-db@lists.php.net> 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" <raymol@online.no> wrote in message > 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 >