Need Help constructing an INSERT statement

[vincej]

Hi - On the face of it this should be easy but it's not working.  I have products with prices and quantities. Multiplying these gives ordervalue.  However, because there are large numbers of products / prices / quantities these have to be brought in as an array and then I cycle through them with a for loop. This works great. However, now I want to store the order value for each combination. This is where it is failing. 

 

Let me show you the working code and then the NOT working code:

 

This works - But I don't get any *changes*  to ordervalue that the customer may require:

 

$sql ="
INSERT INTO `confirmedorder` (customerid, Prodid, Prodname, pricelb,quantity,price, ordervalue)
VALUES ($customerid,$prodid[$i], '$prodname[$i]','$pricelb[$i]', $quantity[$i],$price[$i], $ordervalue[$i] )
";

$this->db->query($sql);

 

 

If the customer changes his quantities I want a revised ordervalue. This DOES NOT work - the query just fails:

 

$sql ="
INSERT INTO `confirmedorder` (customerid, Prodid, Prodname, pricelb,quantity,price, ordervalue)
VALUES ($customerid,$prodid[$i], '$prodname[$i]','$pricelb[$i]', $quantity[$i],$price[$i], $quantity[$i] * $price[$i] AS  'ordervalue' )
";
$this->db->query($sql); 

 

Can any one PLEASE shine some light how to do this correctly ?

 

Many Thanks !

[awjudd]

You can't use AS in your VALUES clause for an INSERT statement.

 

$sql ="
INSERT INTO `confirmedorder` (customerid, Prodid, Prodname, pricelb,quantity,price, ordervalue)
VALUES ($customerid,$prodid[$i], '$prodname[$i]','$pricelb[$i]', $quantity[$i],$price[$i], " . $quantity[$i] * $price[$i] . " )
";
$this->db->query($sql); 

 

~awjudd