Count Views help needed

[Parker Clack]

What is the query to run for counting thread views?

I have:

$countviews=$DB_site->query_first('SELECT COUNT(*) AS views FROM thread');
$totalviews=number_format($countviews['views']);

Which of course doesn't work. What do I need to change to get this work right?

Thanks,
Parker

[squawell]

i don't test this code so i don't know can work or not

PHP Code:

$countviews=$DB_site->query_first('SELECT COUNT(*) AS threadviews FROM thread'); 
$totalviews=number_format($countviews['threadviews']); 


[Admin]

You need to use SUM
(http://www.mysql.com/doc/G/r/Group_by_functions.html), like this:

$countviews=$DB_site->query_first('SELECT SUM(views) AS totalviews FROM
thread');
$totalviews=number_format($countviews[totalviews]);