PHP MySQL UPDATE query is not updating!
Posted: Wed Jul 21, 2010 9:50 pm
in my paypal ipn_response.php I call this function:
This function is specified in an 'included' class file as such:
As far as I can tell, everything is correct... Just to be sure I tried calling the function in another php file (my registration page) and it updated fine. Any suggestions?? 
Code: Select all
$amount = (int)"3.00";
$paypal_ipn->pay_instructor($amount); This function is specified in an 'included' class file as such:
Code: Select all
function pay_instructor($amount){
// aj - Add commission to referring instructors account in com_profiler table
$qry = "UPDATE jos_comprofiler SET accountbal = accountbal + ". $amount ." WHERE id = '" . $_COOKIE['refidC'] . "'";
mysql_query($qry);
}