Code is wrong?

[kpowning]

Here is my code... Everythings seems to work fine except for the if statement I have included in this script. It seems that I get no query results for $do. Why would this be happening. There is a number in the table for this field being selected.

$id=6; //set this to the usergroup you want to upgrade the user to
$post=60; // set this to include a minimum post amount required
$referals=1; // set the number of referrals required in order to be promoted
$max=1;
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM 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");
while ($referrer=$DB_site->fetch_array($referrers)) { 
  $referreds = $DB_site->query("SELECT username FROM user WHERE referrerid = '$referrer[userid]' AND referrerid > 0");
//echo $referrer[username];
$do=$DB_site->query("SELECT usergroupid FROM user WHERE referrerid = '$referrer[userid]'");
if ('$id'==$do['usergroupid']){
$msg = "No records were updated $do";
exit();
} else {
$update = $DB_site->query("UPDATE user SET usergroupid=$id WHERE posts > $post AND username='$referrer[username]'");
//echo $referrer['username'];
//echo $referrer['referrals'];
$msg = "update successfull - $referrer[username](s) usergroupid has been updated to '$id'";
}
}
echo $msg;

[laserlight]

Remove the single quotes enclosing $id

You should also read the PHP manual concerning strings.

[kpowning]

Thanks for the quick response.. Yes, I'm a newbie here, i will look into that article, but can you point me into what might i need to watch out for in my strings?? I will also try your suggestion to see if that makes the script work.

[kpowning]

I don't think that worked.. All i see being printed/ echod is:
update successfull - gspot(s) usergroupid has been updated to '6'
////////////////////////////////////////////////////////////////////////////////////
When this users usergroupid was already 6
////////////////////////////////////////////////////////////////////////////////////
???

[laserlight]

And when you test with id 5 instead?

I have a hunch that you arent using your database wrapper properly.

Echo out $do to check.

[kpowning]

Resource id #16

[laserlight]

Yep, the problem is that you need one more step before you can start using $do['usergroupid']

You need a function that returns an array based on the resource.
It might be
$do = $DB_site->get_array($do);

but you'll have to refer to your DB wrapper to find out.