07.02.2014, 19:15
This is the full query:
To show:
@sammp thanks, but i already have my own code to show the list.
Код:
<?php $PlayersBanned = mysql_query("SELECT * FROM `playerdata` WHERE `Banned` IS NULL OR `Banned` = 0 AND `Admin` > 0 ORDER BY `playerdata`.`PlayersBanned` DESC LIMIT 0, 10") ?>
Код:
<br><br><strong>Ban Hammers (Admins Who Banned Most)</strong> <br><?php while($row = mysql_fetch_array($PlayersBanned)) { echo "<tr>"; echo "<br><td>".$row["user"]." <td>".$row["PlayersBanned"]."</td></td>"; echo "</tr>"; } ?> <br><br>