Hello all. I was wondering if anyone had an easy way to advance the mysql pointer in a query.

This is the situation: I have a table that contains samples. I want to build a page that has a previous and next buttons. But to show one sample at a time.

Of course I could use
PHP Code:
and increase the offset each time. But I was wondering if there was a way to do it without requering the db every time they hit next or previous.