Count_all_result problem

[eluser]rochellecanale[/eluser]
Hey guys i used the count_all_result in my page to display selected data. But when i display my selected data it does not give a correct count.
My data in the table is actually 12 items but when i display it in the page it gives 11 where's the other one? help me guys please.

[eluser]Otemu[/eluser]
Hi,

Add this to your controller:

Code:

$this->output->enable_profiler(TRUE);

Wth this enabled your be able to see the query being produced and run it on your database to see if it actually is returning 11 or 12 results.

If you test the query and it is still producing 12 then your need to post your code so we can try solve your issue.

[eluser]rochellecanale[/eluser]
i used another way i add 1 to the beginning of the count.

[eluser]siptik[/eluser]
but it's bad practice! find real problem, because you will have more problems where you will have other count of rows.
Sorry my English is bad/