Problem in Pagination

[eluser]Thorpe Obazee[/eluser]
Try using the AR. I assume the problem occurs on the first page only. Nothing is preventing the ',' comma from getting in your query which causes the error.

Code:

$this->db->where(array('userId' <> =>$user_id, 'deleted' => 0));
$this->db->order_by('username');
$this->db->limit($num, $offset);
$query = $this->db->get('tms_user');

if ($query->num_rows() > 0)
{
    return $query->result();
}
return FALSE;