Problem in Pagination

[eluser]zombica[/eluser]
Here it goes....

//Get All users data
function get_all_user($num,$offset,$user_id)
{
$query = $this->db->query("SELECT * from tms_user where userId <> $user_id and deleted='0' order by username LIMIT ".$num.",".$offset." ");
$result=$query->result();
return $result;
}