nun war ich grad dabei die Rangliste zuverändern
Das sieht jetzt leider so aus :

Es sollte eig. so sein:
| Platz----Name----Level |
| 1--------Name--------1 |
| 2--------Name--------2 |
| 3--------Name--------3 |
Ohne "----"
Hier meine ein Teil meiner Index.php:
HTML Code:
<div class="sb-title"><h3>Rangliste</h3></div> <div class="sb-con"> <div class="sb-con-wrap"> <p> <tr class="top_top"> <td class='rank'>#</td> <td width='3'>Platz</td> <td width='3'>Name</td> <td width='70'>Level</td> </tr></table> <hr class="ranking_hr" /> <table class="top" cellspacing="0" cellpadding="0"> <?PHP include("./inc/top.php"); ?> </table>
Und hier die dazugehörige top.php:
HTML Code:
<br><br> <center> <table border="0" width="190"> <?PHP $sql = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name FROM player.player LEFT JOIN player.player_index ON player_index.id=player.account_id LEFT JOIN player.guild_member ON guild_member.pid=player.id LEFT JOIN player.guild ON guild.id=guild_member.guild_id INNER JOIN account.account ON account.id=player.account_id WHERE player.name NOT LIKE '[%]%' AND player.name NOT LIKE '.%#' AND player.name NOT LIKE 'Lijang2' AND account.status!='BLOCK' ORDER BY player.level DESC, player.exp DESC LIMIT 5"; $i = "0" ; $ergebnis = mysql_query($sql,$sqlServ); while($row = mysql_fetch_object($ergebnis)) { $i = $i + 1 ; echo "<tr class='tooltip ranking_rank' title='$row->name | Level: $row->level | Gilde: $row->guild_name'> <td class='rank'>$i</td> <td width='125'>$row->name</td> <td width='54'>$row->level</td> </tr>"; } ?> </table> <br> <a href="?git=ranking">Komplette Rangliste</a> </center>






