Fast question about a query
#6

This is the full query:

Код:
<?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")  
	?>
To show:

Код:
<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>
@sammp thanks, but i already have my own code to show the list.
Reply


Messages In This Thread
Fast question about a query - by Face9000 - 07.02.2014, 18:35
Re: Fast question about a query - by Emmet_ - 07.02.2014, 18:40
Re: Fast question about a query - by Face9000 - 07.02.2014, 18:46
Re: Fast question about a query - by sammp - 07.02.2014, 18:58
Re: Fast question about a query - by GWMPT - 07.02.2014, 19:08
Re: Fast question about a query - by Face9000 - 07.02.2014, 19:15
Re: Fast question about a query - by Mauzen - 08.02.2014, 01:44
Re: Fast question about a query - by Face9000 - 08.02.2014, 09:27

Forum Jump:


Users browsing this thread: 3 Guest(s)