我需要将以下查询取出每日的订单总数和订单总额,并按日期分组。 我使用时间戳存储所有数据。
注意:implode仅用于定义时间段(WHERE created> = TIMESTAMP AND <= TIMESTAMP)
更新:
未使用GROUP BY day
SELECT
COUNT(id) as order_count,
SUM(price + shipping_price) as order_sum,
DAY(FROM_UNIXTIME(created)) as day
FROM `order`
WHERE '.implode(' AND ', $where).'
我需要按天分组,但是当我对最近周末的销售进行分组时,它将我的订单数从3变为1。如何按天提取上述值?注意:implode仅用于定义时间段(WHERE created> = TIMESTAMP AND <= TIMESTAMP)
更新:
未使用GROUP BY day
Array (
[order_count] => 3
[order_sum] => 69.70
[day] => 17
)
按照day
进行分组
Array (
[order_count] => 1
[order_sum] => 24.90
[day] => 17
)
我需要这个查询返回每天的销售情况,订单数量和销售额总和。但我似乎还缺少一个关键部分....