PHP shopping cart stock control problem

[stu673]

Hi there,

I have coded a php/mysql shopping cart with no (major) issues. The problem I am having is that I am trying to implement a stock control system so that when a user calls the checkout.php script I then access the database and adjust the stock number according to what they had in their basket.

This is the code I have written:

$sql = "SELECT * FROM cart_items WHERE order_id=$order_id";

$result = mysql_query($sql,$conn)
	or die("couldn't execute query");


while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{

extract($row);

$sql2 = "SELECT product_id, quantity FROM cart_items WHERE order_id=$order_id";

$result2 = mysql_query($sql2,$conn)
	or die("couldn't execute query");

$row2 = mysql_fetch_array($result2,MYSQL_ASSOC);

extract($row2);

$sql3 = "UPDATE product SET stockno=stockno-$quantity WHERE id=$product_id";

$result3 = mysql_query($sql3,$conn)
	or die("couldn't execute query");


}

This code works find when there is just one item or one row of many of the same items, but refuses to work with more than one product. Instead it just seems to delete the number of different items in the basket from the stock number of the first item.

Help?!

[MoralTerror]

when you are updating the stock no you need to loop through the array something like

for ($i = 0; $i <items_ordered; $i++)
$sql3 = "UPDATE product SET stockno=stockno-$quantity WHERE id=$product_id";

where items_ordered would be a count of different items ordered