Pagination automated

[eluser]dine[/eluser]

Code:

$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'];

        // Initialize pagination
        $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);
        //}
        $query.= " Limit ".$this->pagination->offset.",".$config['per_page'];

        echo $query;
        //echo $config['per_page']."::::::::::".$this->pagination->offset;
        $sql = $this->db->query($query);

when i add limit in my query.it's working but now no paging links comes.