Using stored functions in Active Record

[eluser]arslan ali[/eluser]
i was looking for following query

Code:

SELECT * FROM (`banners`) WHERE banner_type = Menu AND status =Active AND start_date>=current_date() ORDER BY `id` desc

After looking above post i tried this code and it worked magically for me.

Code:

$this->db->select(*);
$this->db->from('banners');
$this->db->where(array('banner_type'=>'Menu','status'=>'Active','start_date>=current_date()'=>"",'end_date>=current_date()'=>""))