[color=red]<?[/color]

openside("Top 5 Forum Users");

$result=dbquery("SELECT user_name, user_id, count(user_id) AS post_count FROM ".$fusion_prefix."posts INNER JOIN

".$fusion_prefix."users ON post_author=user_id GROUP BY user_name ORDER BY post_count DESC LIMIT 0,5");

echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" class=\"\">";

if(dbrows($result)!=0){

while($data=dbarray($result)){

echo "<tr><td class=\"small\" align=\"left\"><a href=\"/html/profile.php?lookup=$data[user_id]\">";

echo "$data[user_name]</a></td><td class=\"small2\" align=\"right\">$data[post_count]</td></tr>";

}

}

echo "</table>";

closeside();

[color=red]?>[/color]