Displaying data from a mysql database from start date to end date using php where user provides the start and end date -

hi how display data mysql database start date end date using php codeigniter user provides start , end date through view page.. start , end date been fetched view page.... should able fetch values start date till end date mysql database.. ....

i output... displays current date

2009-11-01 00:00:00 select * border dateordered='2009-11-01 00:00:00'2011-05-04no records found2010-11-01 00:00:00 gave start date 04-05-2011 , end date 05-05-2011

$sql = 'select * table order start_date asc'; $q = $this->db->query($sql);  $results = ($q ? $q->result() : false); 

there go....