Und da möchte ich zu TOP PLAYER in Level Auf Kills setzen.
Die Kills werden in player.kills gezählt.
Code:
<table width="166" cellspacing="-1" class="player-table"> <tr class="trTop"> <td width="24" align="center">#</td> <td width="91" style="text-indent:5px;">Player</td> <td width="43" align="center">x</td> </tr> <?php $topQry = mysql_query(" SELECT player.name,player.kills,player_index.empire FROM player.player LEFT JOIN player.player_index ON player_index.id = player.account_id INNER JOIN account.account ON account.id=player.account_id WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' ORDER BY player.kills Limit 5"); while($topfetch = mysql_fetch_object($topQry)) { $r++; ?> <tr> <td width="24" align="center"><?php echo $r; ?></td> <td width="91" style="text-indent:5px;"><?php echo $topfetch->name; ?></td> <td width="43" align="center"><?php echo $topfetch->level; ?></td> </tr> <?php } ?> </table>
MFG.