How can i write this query in active record in codeigniter.
SELECT * FROM `post_ads` WHERE `dates` >= '2014-09-20' AND `dates` <= '2014-09-22' ORDER BY `dates` ASC
I tried this code but gave an empty array.
$where = "DATE(dates) BETWEEN '2014-09-20' AND '2014-09-22'";
$query = $this->db->where($where)->get('post_ads');
return $query->result();