Subtracting stock quantity for more than 1 item

I'm successfully deleting an eCart's quantity from the field LampInventory on my checkout_success.php based on dlovas275157 solution:

$FinalStack = $eCart1->DisplayInfo("subtractions");

$idProduct = $eCart1->DisplayInfo("ID");



mysql_select_db($database_connChan, $connChan);

$subtractions = mysql_query("UPDATE Lamps SET LampInventory = '$FinalStack' WHERE LampID = '$idProduct'") or die(mysql_error());

How can I make it work for more than just the first item in the cart. Do I need to create an array or loop? If so any examples please.

Thanks

yes, you need to loop through the cart items.

$eCart1->MoveFirst();

while (!$eCart1->EOF())      {

    $FinalStack = $eCart1->DisplayInfo("subtractions");

    $idProduct = $eCart1->DisplayInfo("ID");



    mysql_select_db($database_connChan, $connChan);

    $subtractions = mysql_query("UPDATE Lamps SET LampInventory = '$FinalStack' WHERE LampID = '$idProduct'") or die(mysql_error());

 $eCart1->MoveNext();

}

$eCart1->MoveFirst();

Thanks Jason, that seems to work perfectly.

Now I'm going to learn why :-)

OK, here's why:

your original code would only ever execute one time for the first item in the cart.

by adding a cart loop:
while (!$eCart1->EOF()) {
<do stuff>
$eCart1->MoveNext();
}


the code will execute once for each line item in the cart. the line:
$eCart1->MoveNext();

moves the reference to the next line item.