我正在为一个车展编写脚本。用户选择汽车号码,并根据各种标准投票1-5。有多个用户为同一辆车投票,但他们只能为每辆车投票一次,我对此进行了检查。
现在我有一个表,表中有一辆车的唯一编号,每辆车的每个标准有1-5票。
以下是我如何找到每个用户投票的总分
SELECT carNum, exterior+interior+engine AS Score FROM Judge_Votes WHERE catagory = '$catNum' ORDER BY carNum
Reults
CarNum: Score:
18 11
14 8
13 15
12 8
12 11
2 14
我想把每个用户的总分加起来,得到一个最终的分数结果。IE车12总分19分。
我有个问题。如何使用sql或php查找总分?
只需使用SUM和ORDER BY:
SELECT carNum, SUM(exterior+interior+engine) AS Score
FROM Judge_Votes
WHERE catagory = '$catNum'
GROUP BY carNum
这应该做的"把戏"
SELECT carNum, sum(exterior + interior + engine) as Score
FROM Judge_Votes
WHERE gatagory = '$catNum'
GROUP BY carNum
ORDER BY carNum
我认为以下内容应该可以解决问题。逻辑是将结果分组到每辆车(group BY carNum),然后使用SQL的内置SUM函数。
SELECT SUM(exterior+interior+engine) as totalScore, carNum
FROM Judge_Votes
WHERE catagory = '$catNum'
GROUP BY carNum
ORDER BY carNum;