in reply to Calculating previous/next from database
I usually use DBIx::Class and it's paging ability via the Data::Page module. It makes this sort of thing very easy.
Frank Wiles <frank@revsys.com> www.revsys.com