title: use_page_numbers in codeigniter pagination class?
body: <p>I have a problem with using use_page_numbers config set to true in my pagination class! 
  When I click on the link of page 2, the number of rows it retrieves from database is correct, but the problem is that:
  the first row of page 2 is the third row of page one ! It means that page 2 starts with the same row from the database which has been retrieved in the first page in the third row. for example :</p>
  
  <p>Page 1: 10, 11, 12, 13, 14</p>
  
  <p>Page 2: 12, 13, 14, 15, 16</p>
  
  <p>and of course the page 3 starts from the second row of page 2 :</p>
  
  <p>Page 3: 13, 14, 15, 16, 17</p>
  
  <p>This is the code I have :</p>
  
  <pre><code>function get_brands_list($options = array())
  {
      //Pagination config
      $config['base_url'] = base_url() . 'admin/brands/page/';
      $config['total_rows'] = $this-&gt;db-&gt;get('mg_brands')-&gt;num_rows();
      $config['per_page'] = 5;
      $config['num_links'] = 4;
      $config['uri_segment'] = 4;
      $config['use_page_numbers'] = TRUE;
  
      $this-&gt;pagination-&gt;initialize($config);
  
      $offset = $this-&gt;uri-&gt;segment(4, 0);
      $this-&gt;db-&gt;order_by('brand_Sort', 'ASC');
      $query = $this-&gt;db-&gt;get('mg_brands', $config['per_page'], $offset);
  
      if(isset($options['brand_Id']) || isset($options['brand_Name']))
          return $query-&gt;row(0);
  
      return $query-&gt;result();
  } 
  </code></pre>