Discount Record Not Updating In Confirm.php
I have the attached confirm.php file. Two process are not updating correctly.
1. I want to update the Recordset (discounts) with the value 1 in the discountStatus field so the discount can not be reused
2. The orders table should have the discounts.discountQty value populating the orders.OrderDiscQty field, but that is not working either.
Can you help please?. I am attaching the confirm.php and the site credentials privately. If you need a test discount code, use "TESTMIKE"