php - Codeigniter 中 AND 的事件记录

Question

我如何在 codeigniter 的事件记录中写入此查询。

 SELECT * FROM `post_ads` WHERE `dates` >= '2014-09-20' AND `dates` <= '2014-09-22' ORDER BY `dates` ASC

我试过这段代码，但给出了一个空数组。

 $where = "DATE(dates) BETWEEN '2014-09-20' AND '2014-09-22'";
    $query = $this->db->where($where)->get('post_ads');
    return $query->result();

Answer 1

像这样重复两次:

$this->db->select();
$this->db->from('post_ads');
$this->db->where('dates','2014-09-20');
$this->db->where('dates','2014-09-22');
$this->db->order_by('dates');