What would be the best way to step through a few thousand records?

The way I'm doing it currently is to have an identifier field and everytime a user clicks a link or a button, it grabs the next record based on that identifier.

Would it be easier to stuff the entire table into an array and just pull from the array?

I'm not sure where to go on this one.