在PHP / HTML页面中显示MySQL表计数[关闭]

I want to display the current amount of users registered in my database (it's called dalton) / the users are stored in a table in that database called simpleauth_players. It stores their name, hash, registerdate, logindate, and lastip.

I want to somehow use a PHP code that (logs me into the database) and displays the current amount of names in the database. So I can display a message like "Hey, there is currently 1,894 registered players!" inside of my HTML/PHP page. I'm kinda a novice it would be awesome if somebody could share the code and instructions.

My code:

$connection = mysql_connect('host', 'username', 'password');
mysql_select_db('database');

$query = "SELECT * FROM simpleauth_players"; 
$result = mysql_query($query);
$registered = "SELECT COUNT(*) FROM dalton.tables WHERE simpleauth_players = 'name' and     TABLE_TYPE='BASE TABLE';

echo "$registered"; 

mysql_close(); 

All of my information is down here! Database Server: Server: Localhost via UNIX socket Server type: MariaDB Server version: 5.5.39-MariaDB - Source distribution Protocol version: 10 Server charset: UTF-8 Unicode (utf8) Web Server: Apache Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $ PHP extension: mysqli phpMyAdmin: Version information: 4.1.14

Try this:

$num_rows = mysql_num_rows($result);