Paging in mysql store procedure? need help

[Aniia]

How to do paging in mysql store procedure??

input paramter will be (in pageno INT, IN no_records)

result will be for example i pass value 1 and 10 : first 10 records it will show.
or 2 and 10 then it will show 11 to 20 records.. please help..

[Luuk]

search for 'MySQL' and 'LIMIT'

SELECT something
FROM tablename
LIMIT 3,5

will return from the 3rd row the next 5 rows....