I am desperate to make this work but just don’t quite understand it.
I have several problems.
I am not completely sure how to create a loop, although I have tried. Details on what I have done are below.
Firstly, I am using express checkout so the payment transaction is always completed in my site.
When the transaction is complete I store information in two db files. Orders, OrderDetails.
Checkout works as follows, users add an item to their cart, click checkout, go to PayPal to enter details, return to my site, click checkout, payment is processed (Info inserted into database) and then redirects the user to the success page which has a order receipt.
I want to make the system subtract the quantity of each product purchased from the product stock value stored in my products table.
To do this I did:
On the checkout success page, I have a record set which joins the products, and order details tables.
I filter that based on the "eCart_OrderID" session variable.
Then and the very bottom of my code I tried to add your code (Not sure how to make a loop so not sure if this is correct):
($ProductStock = ($ProductStock - $DetailQuantity))
$DetailOrderID' = "#ProductID"
$updateSQL = sprintf("UPDATE products SET STOCK_LEVEL='$ProductStock' WHERE Ref='$DetailOrderID'");
ProductStock: Products table stock amount
DetailQuantity: Order Quantity for each product
DetailOrderID: Transaction ID
ProductID: Products ID
Could you please tell me what I am doing wrong?
Thank you for your help