Hello again,
I have another question, kind of a continuation of my previous question. Here is my code for a generic multi-level referral system:
if ($submit) {
$db = mysql_connect("host", "user", "pass");
mysql_select_db("db");
$n=0;
$n2=0;
$n3=0;
$res=mysql_query("SELECT * FROM membertest WHERE referrer='$user'",$db);
while($row=mysql_fetch_array($res))
{
$r=$row['referrer'];
$points=$row['points'];
$lone=$row['member'];
$n++;
$totalpoints=($totalpoints+$points);
}
$res2=mysql_query("SELECT * FROM membertest WHERE referrer='$lone'",$db);
while($row2=mysql_fetch_array($res2))
{
$r2=$row2['referrer'];
$points2=$row2['points'];
$ltwo=$row2['member'];
$n2++;
$totalpoints2=($totalpoints2+$points2);
}
$res3=mysql_query("SELECT * FROM membertest WHERE referrer='$ltwo'",$db);
while($row3=mysql_fetch_array($res3))
{
$r3=$row3['referrer'];
$points3=$row3['points'];
$lthree=$row3['member'];
$n3++;
$totalpoints3=($totalpoints3+$points3);
}
echo "$n first level referrals totaling $totalpoints points<br>";
echo "$n2 second level referrals totaling $totalpoints2 points<br>";
echo "$n3 third level referrals totaling $totalpoints3 points<br>";
}
else {
?>
<form name="nmtestform" method="post" action="<?php echo $PHP_SELF?>" ONSUBMIT="return valid()">
<font face="Verdana, Arial, Helvetica"><font size="2"><center>Member ID<p>
<input type="text" name="user" size="40" maxlength=100><br>
<input type="Submit" name="submit" value="Submit Form!">
</form>
<?php
}
?>
I have a little problem though...The code outputs 2 first level referrals, 2 second level referrals, and 2 third level referrals. In my test db I have each 'member' refer two other members, so the output should be 2 first level, 4 second level, and 8 third level. The PHP script isn't grabbing any records.
Please tell me what I'm doing wrong. ANY help is greatly appreciated. I'm a relative PHP newbie and I just can't get this to work.
Thank you so much,
Barry
