hab es hinbekommen.

so geht es:

<?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>
<td align="center"><b>Rang:</b> '. $rang++ .'</td>
<td align="center"><b>Nick:</b> '.$klickliste[nickname].'</td>
<td align="center"><b>Klicks:</b> '.number_format($klickliste[klicks],0,",",".").'</td>
</tr>
';
}
menuefoot();?>


Danke euch