PHP/MySql比较过去7天和最后7天之前的数据

Question

我试图将我对过去7天数据(24-10-2018至31-10-2018)的查询数与该周之前的数据(16-10-2018至23-10-2018)进行比较。我的查询Mysql表结构如下：

=================================
id | enquiry_date | enquiry_desc
=================================
 1     16-10-2018    Test Data
 2     17-10-2018    Test Data
 3     18-10-2018    Test Data
 4     18-10-2018    Test Data
 5     20-10-2018    Test Data
 6     24-10-2018    Test Data
 7     25-10-2018    Test Data
 8     28-10-2018    Test Data
=================================

So the result should be 

Last week count (16-10-2018 to 23-10-2018) : 5
This Week count (24-10-2018 to 31-10-2018) : 3 

刚开始的时候，有人能给我一个如何开始的指导吗？我可以通过一个查询来实现这一点吗？

Answer 1

嗨，三居这是没有测试，但它的帮助，首先检查您的日期格式比尝试下面

SELECT count(id) AS last_week FROM table_name
WHERE enquiry_date >= date_sub(current_date, INTERVAL 14 day) 
AND enquiry_date < date_sub(current_date, INTERVAL 7 day)
UNION
SELECT count(id) AS this_week FROM table_name
WHERE enquiry_date >= date_sub(current_date, INTERVAL 7 day)