08.08.2015, 14:04
(
Последний раз редактировалось muhsah007; 08.08.2015 в 14:38.
)
PHP код:
mysql_format(MySQLCon, szQuery, sizeof(szQuery), "select Faction, count(*) from players GROUP BY Faction");
it shows like this
PHP код:
+---+------+----+
| Faction | COUNT(*) |
+---+------+----+
| 2 | 1 |
| 3 | 2 |
+---+------+----+
i want a mysql code to give me result like this
PHP код:
+---+------+----+
| Faction | COUNT(*) |
+---+------+----+
| 0 | 0 |
| 1 | 0 |
| 2 | 1 |
| 3 | 2 |
| 4 | 0 |
| 5 | 0 |
| 6 | 0 |
+---+------+----+