Getting total # of threads for certain forums on non vb page?

[Gutspiller]

Originally posted by Logician
You can use the algorithm:

https://vborg.vbsupport.ru/showthrea...926#post276926

Change the query to anything you like and it will display any info you queried in a non-vb page.

Needless to say, you need to insert this code into a page with .php extension..

I put

PHP Code:

<?

require("admin/config.php");
mysql_connect("$servername", "$dbusername", "$dbpassword") or die("Couldnt find MYSQL!");
mysql_select_db("$dbname")  or die ("Couldnt find DB!");
$totalviews=mysql_query("SELECT SUM(views) AS threadviews FROM thread");
if (mysql_error()) {echo "mySQL error:"; echo mysql_error(); exit;}
else
{echo mysql_result($totalviews,0);} 
?>

into my frontpage, but it only shows the totalviews. How do I change it so that it shows the total threads that have been made in a certain forum?