如何在php中回显所有5天的计数值？
如何在php中回显所有5天的计数值？
提问于 2018-06-25 00:54:53
SELECT dateofbooking, count(id) AS total FROM participant WHERE dateofbooking >= $datepick AND
dateofbooking <= DATE_ADD($datepick, INTERVAL 5 DAY)GROUP BY dateofbooking;如何在php中回显所有5天的计数值？
回答 1
Stack Overflow用户
发布于 2018-06-25 02:14:27
使用此代码
$from = date('Y-m-d');
$to = date('Y-m-d',strtotime("5 day"));
SELECT dateofbooking, count(id) AS total FROM participant WHERE `dateofbooking` BETWEEN '$from' AND '$to' GROUP BY dateofbooking;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51012055
复制相关文章
相似问题