[tubedogg]

Originally Posted by okc

Can anyone tell me how to calculate totalviews of a forum - I want to put this on my forumhome instead of # of posts.

I see a lot of hacks with this included but there's so much other crap I don't want - can't I just get the $totalviews string from anywhere?

thx alot

You could do
SELECT SUM(views) FROM thread;
but that would cause a full table scan every time which if you have a lot of threads could be A Bad Thing?.