Finding total posts in a specific forum

[kgroneman]

I want to find the number of total posts in a specific forum. It's easy to find number of threads, but I'm having a hard time finding posts. I tried this sql query:

SELECT COUNT(postid) AS count
FROM vb_post
[FONT=monospace]WHERE forumid = '671'[/FONT]

But forumid isn't a column in vb_post. Can someone tell me how to find total posts in a forum? Thanks in advance.

[Bat21]

Isn't this one of the options that can be displayed by simply choosing it from the adminCP.

[Wayne Luke]

This should show on your front page in the forum listing. However...

You would have to join in the `thread` table on the threadid.

SELECT COUNT(p.postid) AS count
FROM vb_post AS p
JOIN vb_thread AS t ON (p.threadid=t.threadid)
WHERE t.forumid = '671'

[kgroneman]

Somebody needs to kick me. I'm so used to working from the back end I forget to look at the front end! LOL! Pretend I wasn't even here......