query to get number of forums in category?

[wtrk]

how can i automatically count the number of forums in a category?

[Cryo]

SELECT
    count(forumid) AS forums
FROM
    forum
WHERE
    parentid = 5

Replace the "5" in parentid with the ID of the forum that is serving as the category. You'll need to add a prefix in front of "forum" if you have your vB installed using one.

[wtrk]

thanks

[Dismounted]

Note that the query will not count sub-forums. Also, you are probably better off using data from the datastore (although this is a little more advanced).