Referral Count?

[jj20051]

I Made An Affiliate Program Script and In The Script It Records Who Referred A User By The Referrer's Database Id. I Would Like To Add A Feature To The Members Area That Counts How Many People A Person Has Referred. The Referrer Column Is Called uReferrer and the Table Is Users.

[Andy-H]

$query = "SELECT COUNT( * ) AS refs FROM Users WHERE uRefferer = '$refferingUsersID'";
$result = mysql_query($query)or trigger_error(mysql_error());

$row = mysql_fetch_object($result);

echo 'Total users reffered: ' . number_format($row->refs);