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: