gistfile1.aw

for($i=0;$i<count($prod);++$i)
{
$query = "INSERT INTO purchase_items (quant,pib,price,id) VALUES ({$quant[$i]},{$pib[$i]},{$ppu[$i]},NULL)";
$query = "INSERT INTO purchases (orderno,,vendor,id) VALUES ('$pnumber','$vend',NULL)";
$result = mysql_query($query);
if (!$result) die ("Database access failed: " . mysql_error());
else {
    echo "Created";
   } 

//add each row to the database here
}