好吧,我有一个名为"sales_records"的mysql表,如下所示:
User saleType +-------+-------+------+ | Jeff | Sale_Closed | +-------+-------+------+ | Jeff | Sale_null | +-------+-------+------+ | Sean | sale_closed | +-------+-------+------+ | Jeff | sale_closed | +-------+-------+------+ | Sean | sale_closed | +-------+-------+------+ | Mark | Sale_null | +-------+-------+------+ | Mark | sale_closed | +-------+-------+------+ | Josh | sale_closed | +-------+-------+------+ | Josh | sale_closed | +-------+-------+------+
我正在尝试为每个用户计算每个saleType ..换句话说.. Jeff有2个"sale_closed"和1个"sale_null .Mark有1个"sale_closed"和1个"sale_null",依此类推......
并将其存储到一个数组..(Json)像这样:
{"jeff":{"sale_closed":2,"sale_null":1},"sean":{"sale_closed":2},"Mark":{"sale_closed":1, "sale_null":1},"Josh":{"sale_closed":2}
好的,所以这是我的尝试:
Mosty Mostac.. 5
您可以在单个查询中获取所需的所有数据:
SELECT user, saleType, count(*) totalSales FROM sales_record GROUP BY user, saleType
这将返回3列中的所有结果,这些列应该很容易变成JSon.