undefined table data, pagination related

[eluser]CroNiX[/eluser]
If you are using a where in your query to get the results, you need to use the same where when you are getting the count.

lets say you had 50 males and 50 females.
If you query to get males, you get 50, but your count function is still returning 100 because you don't have the same where (only males) in it.