Jak zablokować przedrostek [GM] na stronie w rankingu?

[ui999]

w jaki sposób zablokować [GM] itp na stronie w rankingu

[Thexey]

$query = mysql_query("SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[HA]%' AND name NOT LIKE '[sGM]%' ORDER BY level desc, exp desc limit 5");

[ui999]

a w którym miejscu to dokładnie wkleic ?

[Thexey]

u mnie to tak wygląda:

<div id="main">

<div id="sidebar-right" class="sidebar">

<div class="sb-ui sb-title">

<br>

<span>  <img src="images/graczy.png" />  </span>

</div>

<div class="sb-ui sb-cont">

<div class=" sb-middle">

<div id="userInfo">

<div class="text">

 

<img src="images/pasek.png" />

<table id="sbRanking" border="0" cellpadding="0" cellspacing="0" width="200">

  <tbody>

 

    <tr>

 

      <th class="sbrc1" scope="col">Rank</th>

 

      <th class="sbrc2" scope="col">Nick</th>

 

      <th class="sbrc3" scope="col">Lvl</th>

 

    </tr>

<tr></tr>

<?php 

require_once("ustaw/config.php");

$database = mysql_select_db("player");

$query = mysql_query("SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' AND name NOT LIKE '[HA]%' AND name NOT LIKE '[sGM]%' ORDER BY level desc, exp desc limit 5");

$i = 1;

 

while($player = mysql_fetch_array($query))

 

            if($player["name"] != GM) {

         

        echo"<tr><td class='sbrc1'>".$i."</td><td class='sbrc2'><a href='sygna.php?id=".$player["id"]." '>".$player["name"]."</a></td><td class='sbrc3'> [".$player["level"]."]</td></tr>";        

 

$i++;

}

 ?>

  </tbody>

</table>