[Xenon]

no, that wouldn't work, you use the same variablename for three different things...

this would work:

PHP Code:

$topts=$DB_site->query("SELECT COUNT(threadid) AS threads, username LEFT JOIN user ON(user.userid=thread.postuserid) GROUP BY thread.postuserid ORDER BY threads DESC LIMIT 10");
$toptbits = "";
while($topt=$DB_site->fetch_array($topts)) {

$threadcount=$topt['threads'];
$topusername=$topt['username'];

    
eval("\$toptbits .= \"".gettemplate('forumhome_topts')."\";");
}
$DB_site->free_result($topts);