Your solution is quite general, but I don't like the idea of retrieving all the records every time I need to build next and previous links in a page; why don't you use the LIMIT/OFFSET clause available under PostgreSQL and MySQL?