[gspot]

TRY THIS:

PHP Code:

$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM precisi_forums.user AS users 
                   LEFT JOIN user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT $max"); 


AND THEN CHANGE THE OTHER QUERY TO:

PHP Code:

$referreds = $DB_site->query("SELECT username FROM precisi_forums.user WHERE referrerid = '$referrer[userid]' AND referrerid > 0"); 


Once those changes are made, that should work.. Just let me know.