I have the following code. It basically queries the database and shows the following results:
1) Username that referred members
2) How many they referred (count)
3) The usernames of the referred members
I'm wondering how I can make this script only show 1-3 from above if #1 has a referred member that has also referred a certain quantity of members.
Please help me on this, I don't completely understand the joining of tables on mysql queries any point in the right direction would be greatly appreciated.
$max=10; //This number decides how many results to display
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT $max");
while ($referrer=$DB_site->fetch_array($referrers)) {
$referreds = $DB_site->query("SELECT username FROM " . TABLE_PREFIX . "user WHERE referrerid = '$referrer[userid]' AND referrerid > 0");
while ($referred = $DB_site->fetch_array($referreds)){
$enc_username = urlencode($referred[username]);
if ($referrerlist) {
$referrerlist .= ", <A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
} else {
$referrerlist .= "<A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>";
}
}
eval("\$referbits .= \"".fetch_template("referbit")."\";");
$referrerlist="";
}
eval('print_output("' . fetch_template('refer') . '");');
