trying to call forum stats, help!!! i'm sabe

[sabret00the]

i've predefined these

PHP Code:

// Get Community Stats Data
$totalmembers = "SELECT COUNT (*) AS userid FROM user";
$totalthreads = "SELECT COUNT(*) AS threads FROM thread";
$totalposts = "SELECT COUNT(*) AS posts FROM post"; 


then later defined the way i want them displayed

PHP Code:

// Display Community Stats
$fs_members = "Members: $totalmembers";
$fs_threads =  "Threads: $totalthreads";
$fs_posts =  "Posts: $totalposts"; 


then thought that i was supposed to be recalling the info as simple as

	  Community Statistics:<br />
   <?php echo($fs_members); ?><br />
   <?php echo($fs_threads); ?><br />
   <?php echo($fs_posts); ?><br />

but all i get is

Community Statistics:
Members: SELECT COUNT (*) AS userid FROM user
Threads: SELECT COUNT(*) AS threads FROM thread
Posts: SELECT COUNT(*) AS posts FROM post

what am i doing wrong :nervous:

[assassingod]

What you are doing isn't a query

use;

$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']);

$countmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$totalmembers=number_format($countmembers['users']);

[sabret00the]

assassin, you're my savioud, i'm gonna have to dress you up in a red cape and stick an S on your chest

[assassingod]

Originally Posted by sabret00the

assassin, you're my savioud, i'm gonna have to dress you up in a red cape and stick an S on your chest

LOL! Alrighty