Getting Data from vb Database

[tsptom]

On the homepage of my website (not the forum), I list the total number of board members I have. I currently have this hard coded and have been updating this manually each night. Does anyone have any code (html or php) that would automate this - like connect to the vb database and do a Select count(*) from user, and display it?

I'm not sure how to do it.

Thanks

[nico_swd]

PHP Code:


include('./forum_path/global.php');

$query = $db->query("SELECT COUNT(*) AS total FROM ". TABLE_PREFIX ."user");
$users = $db->fetch_array($query);

echo 'Total users: '. $users['total']; 


[grazianno]

thx nico_swd

[tsptom]

Yes, thank you! I'll give that a shot.

[nico_swd]

Note that this code would mess up the "who's online" page since the page where you're gonna put it in is not defined. You can add these lines before including the global.php file to avoid that.

PHP Code:

define('THIS_SCRIPT', basename($_SERVER['PHP_SELF'], '.php'));
define('LOCATION_BYPASS', 1);