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