pagination

[eluser]xwero[/eluser]
@blackdogfnq : i think you better create your own pagination because the CI pagination is not build for that purpose.
In your model you could have these methods

Code:

// returns object with the present first letters
function get_links()
{  
    return $this->db->query('select distinct substring(filename,1,1) as first from table order by substring(filename,1,1)');
}
// returns files with a first letter
function get_files_by_first_letter($letter)
{
   return $this->db->query('select filename from table where filename like "'.$letter.'%"');
}

Pagination of this type is easier because you have a limited range.