Pagination, offset issue

[eluser]Unknown[/eluser]
Hi

I am also new to codeigniter but If you try

$config['query_string_segment'] = 'offset';
$config['page_query_string'] = TRUE;

as

Code:

$this->load->library('pagination');
$config['base_url'] = base_url().'index.php/books/index/';
$config['total_rows'] = $this->db->count_all('books');            //returns 17
$config['per_page'] = '5';
$config['full_tag_open'] = '<p>';
$config['full_tag_close'] = '</p>';
        
$config['query_string_segment'] = 'offset';
$config['page_query_string'] = TRUE;

and then you will get offset in your url
and may be you don't need following code

Code:

if (isset($page) && is_numeric($page))
            {
              $offset = ($page-1) * $config['per_page'];
            }
            else
            {
              $offset = 0;
            }

See if this helps.