Hi,
I am new to php, but slowly getting to grips with it, I am making an online ordering system. Most of it is working apart from a function which updates the status of a Paypal order once an order has been processed.
[php]
//Checks when an orders complete, if paid via paypal, it will display in the admin section that the order is ‘PAID’
if ($sql = “SELECT od_payment_method
FROM tbl_order
WHERE od_payment_method = ‘paypal’”) {
$sql = “UPDATE tbl_order
SET od_status = ‘Paid’”;}
[/php]
This doesn’t seem to work, please can someone put me in the right direction?
Thanks