PHP-Code:
<? menuehead("TagesPlatz"); ?>
<?$klicksrang = db_query("SELECT * FROM ".$db_prefix."_tagrally ORDER BY klicks DESC LIMIT 5");?>
<?
$rang = 1;
while ($klickliste=mysql_fetch_array($klicksrang)) {
$nickname = db_query("SELECT nickname FROM ".$db_prefix."_userdaten WHERE uid = ".$klickliste[uid]." LIMIT 1");
$nickname=mysql_fetch_array($nickname);
$userdaten = mysql_fetch_array(db_query("SELECT * FROM ".$db_prefix."_userdaten WHERE uid=".$klickliste['uid'].""));
echo '</tr>
<td align="center">'.$rang++ .'</td>
<td align="center"><a href="'.$domain.'?content=/nickpage&id='.$userdaten['uid'].'" target="_self">'.$userdaten['nickname'].'</a></td>
<td align="center">'.number_format($klickliste[klicks],0,",",".").'</td>
';
}
?>
<? menuefoot();?>
Gruß Gnom
