one more thing please
im not so good in php & mysql so could u help me with this:
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");
while($topts=$DB_site->fetch_array($topts)) {
$threadcount=$topts['threads'];
$topusername=$topts['username'];
}
eval("\$topts .= \"".gettemplate('forumhome_topts')."\";");
}
$DB_site->free_result($topts);
unset($topts);
would $threadcount return to the number of threads of the user?? and $topusername return to the username???
im not sure.. please tell if there is any mistake