我已经使用下面的代码codeigniter分页。但它列出了所有reocrd从数据库表。分页不工作

$SQL = "SELECT * FROM list AS a ".$search_condition."  "; 
$query = $this->db->query($SQL); 
$finaldata=array();
$finaldata['num_results']= $query->num_rows();      
//how many blogs will be shown in a page
$limit = $finaldata['num_results'];
$start_limit = ($offset-1) * $limit;

echo $SQL = "SELECT * FROM list AS a   ".$search_condition." LIMIT ".$start_limit.",".$limit." "; 
$query = $this->db->query($SQL); 

if($query->num_rows() > 0)
{   
$finaldata['data']= $query->result_array();              
} 

// load pagination library
$this->load->library('pagination');
$config = array();
$config['base_url'] = site_url("adminuser/list");
$config['total_rows'] = $finaldata['num_results'];
$config['per_page'] = $limit;
//which uri segment indicates pagination number
$config['uri_segment'] = 3;
$config['use_page_numbers'] = TRUE;
//max links on a page will be shown
$config['num_links'] = 5;
//various pagination configuration
$config['full_tag_open'] = '<div class="pagination">';
$config['full_tag_close'] = '</div>';
<! some code here ->
$config['cur_tag_close'] = '</span>';
$this->pagination->initialize($config);
$finaldata['pagination'] = $this->pagination->create_links();
$this->load->view('admin/list',$finaldata);

我试着在列表页中每页列出10条记录。但它不起作用