lol, my bad. missing a double quote, and first $count var should have s.
Thanks again for your help Revan and tnguy3n. I now have no errors in the page, the only problem is that the total numbers are not showing up, the only thing that shows up in the page is "Total threads:" but in front of it there is no numbers.
the code that I have so far is,
Code:
<?php
chdir("/home/***/public_html/forums");
require('/home/***/public_html/forums/global.php');
chdir("../");
$count = $DB_site->query("SELECT COUNT(*) AS totalthread FROM " . TABLE_PREFIX . "thread");
while ($count = $DB_site->fetch_array($counts))
{
$totalthread = $count['totalthread'];
}
print ("Total threads: $totalthread");
?>