Pagination automated

[eluser]dine[/eluser]
Hi

I am using your lib. and do the same as you mentioned above.
but I am not getting the exact and expected result.

i am using GET method here.. and query string is like..

Code:

[
http://abc.com/index.php/search/do_search?keywords=&search_type=all&search_in=Entire_Resume&MinYear;=&MinCurrentSalary;=&MaxCurrentSalary;=&City;[]=&Segment;=&Area;=
/code]

I am writing query in search form so my query starts with
[code]
$query = "select SQL_CALC_FOUND_ROWS * from tbl_users where 1=1 ";

after a long if else condition , finally my query saves in $query variable and Before implementing limit I make a clone of this variable

$total_result_query = $query;
$sql_total_query = $this->db->query("Select FOUND_ROWS() as numObjects");
$rs = $sql_total_query->result_array();
$numEvents = $rs[0]['numObjects'];


$config['total_rows'] = $rs[0]['numObjects']; // count all records
$config['per_page'] = 10; // You'd best set rows per page in a config file, but hey
$this->pagination->initialize($config); // initialize pagination


// Create pagination links
$data['pagination_links'] = $this->pagination->create_links();
        
// Retrieve paginated results, using the dynamically determined offset
$this->db->limit($config['per_page'], $this->pagination->offset);
        //}


$sql = $this->db->query($query);

My problem is, query not including limit at the end.


please Guide me as it's very urgent and i am new in this.