pagination not work

[eluser]Jeff Logan[/eluser]
I see what the problem might be...

You need to count the number of records found by your query (without the limit function):

SELECT `userid`, `username` FROM (`ms_user`) WHERE `username` LIKE '%teg%' ORDER BY `username`

I made the same mistake by counting all records.

Let me know if that helps.