That code gave me the following:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/adejones/public_html/membercount.php on line 11
There are no members.
I did get a bit closer with the following though:
$query = "SELECT config_value FROM phpbb_config WHERE config_name='num_users'";
$result = mysql_query($query);
This gives me:
Array ( [config_value] => 974 )
Now I just need to get rid of the array config value bit and have just the number.