NEED help with a loop

kpowning

I NEED YOUR HELP... Do it for your country... 🙂

$users = $DB_site->query(" 
        SELECT COUNT(*) AS count, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users 
        INNER JOIN " . TABLE_PREFIX . "user AS user ON(users.referrerid = user.userid) 
        WHERE users.referrerid <> 0 
        GROUP BY users.referrerid 
        ORDER BY count DESC"); 

$referralcount=$DB_site->query("SELECT COUNT(*) FROM " . TABLE_PREFIX . "user 
                       WHERE referrerid > 0"); 
$referralcounts = mysql_fetch_row($referralcount); 
while ($user=$DB_site->fetch_array($users)) { 

if (($_POST['do'] == 'resetsingle')&&($_POST['member'] != '')){ 
for($i = 1; $i<=$referralcounts[0]; $i++)  

{  

$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET referrals=referrals + {$user['count']} WHERE username='" . $user['username'] . "'"); 
echo "$i: ".time()." <br>";   

}

I'm trying to make this a loop so that all members who have referred people will be updated to the correct total amount of referrals.. CAN YOU PLEASE HELP?? GREATLY APPRECIATED...

kpowning

NO HELP??? PLEASE....

Weedpacket

After only two hours? Some people are still on their lunch break, while others are waiting for you to say what the problem is. But why are you using mysql_fetch_row instead of some $DB method?

Roger_Ramjet

What is the table prefix thing? I'll bet you are proliferating tables when they should all be one table with an identifier column, not seperate table with an identifier prefix.