Ranglistából GM-ek kiszedése (K)

[5310pati]

a webemen ez a ranglista
hogy tudom megoldani hogy a GM-eket ne mutassa?

Kód Kijelölés Kibont

<style type="text/css">
<!--
body,td,th {
color: #999999;
}
.style1 {color: #999999}
-->
</style>
<center>
<table border="0">

  <tr>
  <th width="80">Helyez&eacute;s</th>
    <th width="200"><span class="style1">Név</span></th>
    <th width="200"><span class="style1">Szint</span></th>
    <th width="200"><span class="style1">Birodalom</span></th>
  </tr>
  </table></center>
<p>_______________________________________________________________</p>
<?php
include('config.php');
mysql_select_db('player');
$i = '0';
$sql = "SELECT * from player order by level desc limit 100";
$ergebnis = mysql_query($sql);
echo "<center>";
while($row = mysql_fetch_object($ergebnis))
{
$i = $i+1;
echo "
<table border=\"0\">
<tr><th width=\"80\"><div class=\"text\">$i</div></th><th width=\"200\"><div class=\"text\">$row->name</div></th><th width=\"200\"><div class=\"text\">$row->level</div></th>";
$sql2 = "SELECT * from player_index where id like $row->account_id";
$ergebnis2 = mysql_query($sql2);
$row2 = mysql_fetch_object($ergebnis2);
if($row2->empire == 1)
{
echo "<th width=\"200\"><img src=\"images/shinsoo.jpg\"></th></tr></table>";
}
elseif($row2->empire == 2)
{
echo "<th width=\"200\"><img src=\"images/chunjo.jpg\"></th></tr></table>";
}
elseif($row2->empire == 3)
{
echo "<th width=\"200\"><img src=\"images/jinno.jpg\"></th></tr></table>";
}
}
echo "</center>";
?>


[GooDLiKeHUN]

$sql = "SELECT * FROM player.player WHERE name NOT LIKE '[KING]%' AND name NOT LIKE '[SA]%' AND name NOT LIKE '[SGA]%' AND name NOT LIKE '[SGM]%' AND name NOT LIKE '[GM]%' AND name NOT LIKE '[TGM]%' ORDER BY level desc, exp desc LIMIT 100";
   

Ezt írd ezhelyére:

$sql = "SELECT * from player order by level desc limit 100"

[5310pati]

thx működik
zárom