pagination help

[eluser]WebsiteDuck[/eluser]
Ah well, the first thing I would change is in your controller function, do this:

Code:

somefunction($page=null)

That way you can use $page instead of $this->uri->segment(3)

Secondly, you need to multiply your offset by your $config['per_page']

Code:

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

That should get rid of the mysql error if no page is specified too