<?php //CONNECT TO FORUMS DB// $conn = mysql_connect("localhost","FORUMSDBUSERNAME","DBPASSWORD"); mysql_select_db(FORUMDBNAME) or die(mysql_error()); $members = mysql_query("SELECT * FROM ibf_members");//Selects the member db $total_members = mysql_num_rows ($members);//Counts the # of rows of member db $posts = mysql_query("SELECT * FROM ibf_posts");//Selects post db $total_posts = mysql_num_rows ($posts);//Counts rows of post db ?>
Put That At the top of the page, replace capital letters in $conn
Now somewhere in your page put
<?php echo $total_members; echo $total_posts; ?>
to show the stats