$result_08 = mysql_query("SELECT * FROM `fsr_user_sites` WHERE referred_by_id='$user_site_id'"); while ($row_08 = mysql_fetch_assoc($result_08)) { $ref_user_id = $row_08['id']; $result_10 = mysql_query("SELECT * FROM `fsr_user_sites` WHERE user_id='$ref_user_id'"); while ($row_10 = mysql_fetch_assoc($result10)) { $ref_user_site_id = $row_10['id']; $result_09 = mysql_query("SELECT * FROM `fsr_offer_credits` WHERE user_site_id='$ref_user_site_id'"); $completionTotal_Refs = 0; $totalActiveRefs = 0; while ($row_09 = mysql_fetch_assoc($result_09)) { $any_credit = $row_09['credit_value']; $completion = explode("/", $any_credit); if($completion[1] < 1) { $completion[1] = 1; } $completionCount = ($completion[0] / $completion[1]); $completionTotal_Refs = $completionTotal_Refs + $completionCount; } if($completionTotal_Refs >= 1) { $totalActiveRefs = ($totalActiveRefs + 1); } else { $totalActiveRefs = $totalActiveRefs; } } } print '
Referrals: ' .$totalActiveRefs. ' / ' .$refRequirement. ' '; }