<?php
 
// Defines the login information
$host = "localhost";
$database = "my_database_name";
$username = "my_login";
$password = "my_pass";
 
// Opens a connection and selects the database
$connect = mysql_connect("$host", "$username", "$password");
$db = mysql_select_db("$database");
 
// Create link identifier
$link = mysql_connect("$host", "$username", "$password");
 
// Performs query selcting all fileds in the table in phpbb.. phpbb_users by default
$result = mysql_query("SELECT * FROM phpbb_users", $link);
 
// Defined the number of rows
$num_rows = mysql_num_rows($result);
 
// Since there is an anonymous account subtract 1
$num_rows -= 1;
 
// Displays number of rows with my added font choice
echo "<font face=Verdana size=1 color=484077> $num_rows </font>";
 
?>

// Performs query selcting all fileds in the table
$result = mysql_query("SELECT * FROM phpbb_users", $link);