query problem

[kpowning]

Whats wrong with my script here???

I can't get any results for $count, all the others work though.. I don't get it.. Anyone please help..

$post=0;

$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"); 

while ($referrer=$DB_site->fetch_array($referrers)) { 
  $referreds=$DB_site->query("SELECT username FROM user WHERE referrerid = '$referrer[userid]' AND referrerid > 0 AND posts >= $post");

while ($referred=$DB_site->fetch_array($referreds)){ 
$count=$DB_site->query("SELECT COUNT(*) AS test, user.username FROM user WHERE referrerid = '$referrer[userid]' AND posts >= $post
GROUP BY referrerid
ORDER BY test DESC");

while ($coun=$DB_site->fetch_array($count)){ 
    $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') . '");');

[kpowning]

SO NO ONE CAN HELP ME?? I was hoping to get some feedback on this.. PLEASE ANYONE....

[laserlight]

How do you know you arent getting any results from $count?

As far as I can see, you arent using it to output anything.

[kpowning]

In my template I'm calling $count out for a result and not receiving any information from it. I have tried calling it these two ways:

$count & $count[test]

with no luck..

[kpowning]

Anyone else?? I appreciate the help

[Kudose]

Typo...

while ($coun=$DB_site->fetch_array($count)){  

should be

while ($count=$DB_site->fetch_array($count)){  

at the end of the script add this:

echo $count;

[kpowning]

k - tried that and i get a blank white page, no output... Anything else I should try???

[marky2coats]

Well if you look your varible name $count is the result set from your query. So echoing that isnt going to give anything. By the ooks u need to be echoing $coun

Mark.