Fast question about a query
#1

I'm trying to show in a php page the admin who banned most players (number), currently i got this:

Код:
<?php
	$PlayersBanned = mysql_query("SELECT * FROM `playerdata` WHERE `Banned` IS NULL OR `Banned` = 0 AND WHERE `Admin` > 0 ORDER BY `playerdata`.`PlayersBanned` DESC LIMIT 0, 10")  
	?>
But it doesn't return any nickname. If i remove "AND WHERE `Admin` > 0" i get the correct list. This query is supposed to show just admins starting from level 1.
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: 1 Guest(s)