Pagination issue

[eluser]sv3tli0[/eluser]
Sorry, I am little sleepy let me be clear..
As I see at your code you are making 1 sql to catch data and second to catch count but with different WHERE clauses (first has few clauses and second counts all records)..

This way you have for example:
From 1st query you have 4 records with those where clauses.
And 26 counted at second count because there aren't any WHERE's.

Why you have comment the num_rows() ?

Code:

$config['total_rows'] =  $rows; //$q->num_rows();

This is the second query which is completely different from your first one.

Code:

$rows = $this->db->count_all('code');