Total Views For Forum

If you want to count all the posts for a single forum, use this:

PHP Code:

$forumposts = $DB_site->query_first("
    SELECT COUNT(postid) AS posts
    FROM post
    LEFT JOIN thread ON (thread.threadid = post.threadid)
    WHERE thread.forumid=\"$forumid\"");
$totalposts = number_format($forumposts[posts]); 


and if you want to count all the posts for the entire board, use this:

PHP Code:

$boardposts = $DB_site->query_first("
    SELECT COUNT(postid) AS posts FROM post");
$totalposts = number_format($boardposts[posts]); 


Hope this helps.