Finding total posts in a specific forum
Collapse
X
-
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...... -
This should show on your front page in the forum listing. However...
You would have to join in the `thread` table on the threadid.
Code: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'
Leave a comment:
-
Isn't this one of the options that can be displayed by simply choosing it from the adminCP.Leave a comment:
-
Finding total posts in a specific forum
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:
Code:SELECT COUNT(postid) AS count FROM vb_post [FONT=monospace]WHERE forumid = '671'[/FONT]
Tags: None
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Leave a comment: