我有一个无法解决的问题:(
嗯,我有两次约会,两次。
- 1开始发布的日期
- 1个完成发布的日期
- 1次开始发布
- 1次结束发布
我需要什么?显示最近的记录,即
- 开始发布日期是当前的
- 结束发布日期未完成
- 开始发布时间为当前时间
- 结束发布时间未结束
我试过
start date >= date('Y-m-d') AND
finish date <= date('Y-m-d') AND
(start time) >= date('H:i:s') AND
end time <= date('H:i:s'))
order by ('finish date', 'desc');
在代码Igniter。。
->where("start_date >= '{$today}' AND finish_date <= '{$today}'")
->where("start_time >= '{$time}' AND finish_time <= '{$time}'")
我想念什么?
感谢
我想我修复了它…
(start_date >= $today AND start_time <= $time) AND
(finish_date <= $today AND end_time >= $time)
好吧,这在atm。。。
您需要更改活动的recods查询来自
$this->select(*)->from('table')->where("start_date >= '{$today}' AND finish_date <= '{$today}'")
->where("start_time >= '{$time}' AND finish_time <= '{$time}'")
至
$this->db->query("SELECT * FROM table WHERE start_date BETWEEN {$today} AND finish_date BETWEEN {$today} AND start_time BETWWEN {$time} AND finish_time BETWWEN {$time}");
return $this->db->get()->result();