为什么这对上周的数据拉取不起作用?
if($_GET['reminder'] == 'lastweek') {
$lastweek = date('Y-m-d', strtotime('last sunday'));
$query = "SELECT * FROM contacttodo,contacts WHERE contacttodo.contacts_id = contacts.ID AND contacttodo.reminder BETWEEN '$lastweek' AND '$lastweek' - INTERVAL 6 DAY ORDER BY contacttodo.reminder ASC"; 发布于 2011-08-04 18:13:56
这是BETWEEN的定义:
expr BETWEEN min AND max因此,您应该将较小的值(最小值)放在第一位:
BETWEEN '$lastweek' - INTERVAL 6 DAY AND '$lastweek''$lastweek' - INTERVAL 6 DAY ORDER比'$lastweek'小
https://stackoverflow.com/questions/6938866
复制相似问题