[Vince]

I do not know your entire database structure - so I can't guarantee anything - but I believe this is the query you want;

PHP код:

SELECT Faction, COUNT(*) AS Members FROM players GROUP BY Faction HAVING Faction = '%s' 


If you omit the HAVING Faction part then it will show a list of all factions and the amount of members.