我需要總結總計列的結果：SELECT SUM(number_guest) AS total, booking_time FROM mt_bookingtable WHERE merchant_id IN (SELECT merchant_id FROM mt_merchant WHERE merchant_id = 1 ) AND booking_time BETWEEN "12:00" AND "20:00" AND date_booking like "2020-06-01" AND status in ('pending','approved') GROUP BY booking_time結果我試圖像這樣使用 foreach：foreach ($res as $item) { $sum += $item['total']; return $sum;}但我得到了結果null。
1 回答
哆啦的時光機
TA貢獻1779條經驗 獲得超6個贊
刪除GROUP BY：
SELECT SUM(number_guest) AS total
FROM mt_bookingtable
WHERE merchant_id IN (SELECT merchant_id FROM mt_merchant WHERE merchant_id = 1 ) AND
booking_time BETWEEN '12:00' AND '20:00' AND
date_booking like '2020-06-01' AND
status in ('pending', 'approved');
- 1 回答
- 0 關注
- 153 瀏覽
添加回答
舉報
0/150
提交
取消