what about using LIMIT as a native SQL language construct?
SELECT * FROM tableName LIMIT 0, 10
or in another way:
SELECT $whatever and $whomever FROM $sometable LIMIT $minDisplaySetOff, $maxDisplayRowsPerPage
actually it should read $maxDisplayRowsPerResultSet

Have a nice day
All decision is left to your taste