Pagination Problem

[eluser]Sarfaraz Momin[/eluser]
I think you misinterprete the offset value. Offset value in a query if the record from where the first record of the query begins so it would be always be in multiples for the number of records you want on every page and not increment it by 1 which is in some cases page value when you want to make a custom pagination for your system.

Hope it makes sense.

Have a good day !!!