Probiers mal so:

Code:
<? menuehead("Top5 Klicker"); ?>
$klicksrang = db_query ('SELECT k.klicks,u.nickname FROM '.$db_prefix.'_tagrally k LEFT JOIN '.$db_prefix.'_userdaten u ON u.uid = k.uid ORDER BY klicks DESC LIMIT 5');
$rang = 1;
while ($klickliste=mysql_fetch_array($klicksrang)) {
echo '
<tr bgcolor="#FAEBD7">
<td align="center">'. $rang++ .'</td>
<td align="center">'.$klickliste[nickname].'</td>
<td align="center">'.number_format($klickliste[klicks],0,",",".").'</td>
</tr>
';
}
<? menuefoot(); ?>

*Ist nicht getestet