forum written with codeigniter

[eluser]neph[/eluser]
yeah, when counting two fields i couldnt get them to return each's value, it would just set both counts as the highest of both. if count(cola) was 4 and count(colb) was 2 they would both return as 4...

Code:

mysql> SELECT c.*, COUNT(t.id) numThreads, COUNT(p.id) numPosts
    ->         FROM fm_categories c
    ->         JOIN fm_threads t ON t.categoryID = c.id
    ->         JOIN fm_posts p ON p.threadId = t.id
    ->         GROUP BY t.id, c.id;
+----+--------------------+---------------------------------------+-----------+--------+------------+------------+------------+----------+
| id | name               | description                           | privilege | active | numThreads | numReplies | numThreads | numPosts |
+----+--------------------+---------------------------------------+-----------+--------+------------+------------+------------+----------+
|  1 | General Discussion | This area is for general discussions. |         0 | 1      |          0 |          0 |          5 |        5 |
+----+--------------------+---------------------------------------+-----------+--------+------------+------------+------------+----------+
1 row in set (0.06 sec)

i know it's doable with a "union" but this was just easier for now, it's still needs a lot of work.