php - 如何将我自己的数字插入除法查询中？

Question

我有一个运行良好的查询。唯一的问题是它除以从 select 语句从我的数据库中提取的行数。我该如何改变

(SELECT COUNT(*) FROM saved_players))

可以说 1000 吗？ 1000 是成员(member)总数。

$query= "SELECT *, COUNT(*) AS Total , (COUNT(*) / (SELECT COUNT(*) FROM saved_players)) * 100 AS totalnumber
FROM saved_players
GROUP BY fname";

所以我正在寻找类似下面的东西，但它不起作用。

$query= "SELECT *, COUNT(*) AS Total , (COUNT(*) / 1000 * 100 AS totalnumber
FROM saved_players
GROUP BY fname";

Answer 1

$query= "SELECT *, COUNT(*) AS Total , (COUNT(*) / 1000 * 100) AS totalnumber
FROM saved_players
GROUP BY fname";

看起来缺少括号)。

希望这有帮助