php - 如何从此结果集中求和和计数？

Question

Mysql查询返回结果如下

collector amount    name
1     0.00      gihan
1     2000.00   gihan
1     2500.00   gihan
1     11502.00  gihan
2     1140.00   lasita

我想得到这样的结果数组

collector  amount  count  name
1         16002.00   4    gihan
2          1140.00   1    lasita

知道如何循环结果集以获取匹配收集器的总和，同时获取计数并将结果放入新数组吗？

Answer 1

当您可以让 MySQL 为您完成工作时，您为什么要用 PHP 解决这个问题？

SELECT collector, sum(amount) as amount, count(*) as `count`, name 
FROM yourTable
GROUP BY collector, name