Code: Select all
$qrya = "SELECT refid FROM jos_comprofiler WHERE ID=" . $ref[0];
$refid = mysql_query($qrya); // get referring instructors id
$qry = "UPDATE jos_comprofiler SET accountbal = accountbal + 3 WHERE ID = " . $refid;
mysql_query($qry);
One theory I have: Is it because I am technically calling one MySQL query within another?? If so how can I get around doing this?
Thanks for all your help everyone