[danielpalade]

Quote:

Originally Posted by Vince Yes. GROUP BY does that and it produces one result set that can be read in one go. I usually switch the columns around so groupid is first and member count is second, but it shouldn't matter. A query like this: PHP код: SELECT member AS factionId, COUNT(*) AS memberCount FROM Player GROUP BY member  produces a result like this: factionId memberCount 2 10 4 8 7 13

But the thing is, I need to calculate how many users are in that faction ID.
I don't have a column or something that stores the amount of players in it.
I need something like

Код:

format(string, sizeof(string), "SELECT COUNT(*) FROM `players` WHERE `Member` = '%d'", i);

Where the variabile I would be a variable in a loop, to loop through all the factions available.