Next/Previous MySQL row?

[Haze_Webdesign]

It there a way of fetching the next or previous MySQL row?

I have a database which could get quite large, (5000+ rows) so I don't want to read them all into an array. The users will be starting off on a random record, and I want to be able to offer them a link to the records in the previous and next rows.

Is there a way in MySQL to say "where is the file pointer now?" and "Set it to the previous or next row?"

Please help me if you know the answer!
Thanks,

Neil

[lemon8]

There's a good article on that on phpbuilder.
http://www.phpbuilder.com/columns/rod20001214.php3

It works with setting a LIMIT in your MySQL query and passing a new offset every time the user clicks on :next: or :previous: . This might be useful. Good luck ! :-)