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
Code:
Community Statistics:<br />
<?php echo($fs_members); ?><br />
<?php echo($fs_threads); ?><br />
<?php echo($fs_posts); ?><br />
but all i get is
Quote:
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: