MySQL计数（*）仅计算第一行

Question

The table 'servers' consists of information about some minecraft servers and some of the information is how many players there are currently online, (that row is called "Players") what i want to do is to count how many players there are on all of the servers on that table, so i do

$rt = mysql_query("SELECT Players, COUNT(*) FROM servers") or die(mysql_error());
$row = mysql_fetch_row($rt);
if ($row) {
    echo $row[0];
}

but for some reson those few lines of code only return the number of online players from 1 server, instead of all of the 14 servers
Please help

Answer 1

Does Players hold the number of people? Do you want ALL of them total? If so, it would be

SELECT SUM(Players) FROM servers

If you want it grouped by server

SELECT SUM(Players), id FROM servers GROUP BY id