CI 2.0.2 Pagination Active Page

[eluser]Unknown[/eluser]
Hey,

Trying to use pagination but something is a miss...:

Controller:
$this->load->library('pagination');
$limit = 15;

$config['base_url'] = base_url().'index.php/assignments/date_assigned/' . $assign_date . '/';
$config['total_rows'] = $this->db->count_all('members');;
$config['per_page'] = $limit;
$config['num_links'] = '10';

$this->pagination->initialize($config);
$this->load->model('assignments_model');
$sql = 'SELECT a.attribute, assignment_id, classification_id, assign_time, last_name, first_name, assign_date, comments, seniority_number, previous_assignment, a.member_id, a.assigned_to, a.event_id, a.location_id FROM assignments a, members m
WHERE m.member_id=a.member_id and assign_date = \'' . $assign_date . '\' order by seniority_number ASC';

$data['assignments'] = $this->assignments_model->get_query($sql, $limit, $page);

Model:
function get_query($sql, $num, $offset)
{
$sql = $sql . " Limit $offset, $num";
//echo $sql;
$query = $this->db->query($sql);
return $query
}

The result is my number of links start at 10 and the last item in the pagination links is always active.

Any ideas is appreciated.

[eluser]InsiteFX[/eluser]
Try loading your model before you load the pagination class!
Your calling a model function before the model is loaded...

Code:

$this->load->model('assignments_model');
$this->load->library('pagination');

InsiteFX

[eluser]Unknown[/eluser]
Thanks, but it was the URI segment:

Code:

$config['uri_segment'] = 4;