# www.example.com/?range[0]=2012-07-04⦥[1]=2012-07-06 $range = ( isset($_GET['range']) )? $_GET['range'] : array( 'SYSDATE() - INTERVAL 30 DAY' , 'SYSDATE()'); $orders->where_between('date', $range[0], $range[1])->get(); #result: SELECT * FROM `orders` WHERE `date` BETWEEN 2012-07-04 AND 2012-07-06;
$orders->where_between('date',"'".$range[0]."'","'".$range[1]."'")->get(); #result: SELECT * FROM `orders` WHERE `date` BETWEEN '2012-07-04' AND '2012-07-06';