Get links to previous and next records?

[Thetcm]

I'm opening a page on my website that shows the informations of a specific record and I'd like to have a next and previous button. How do I pull it off? I notice there's no GetNextRecord() function.

I'm using AJAX to show the data, so since everything is brought back by the PHP, it's hard to actually do something with javascript and mess around with arrays, like I originally tried to.

Is there an easy way to do this? I spent the whole day on this yesterday trying various solutions but I couldn't pull it off. I was planning on trying with setRange today.

EDIT I'm currently toying around with a possible idea with record numbers. It would break instantly if I would sort the list, but I could work around that eventually.

EDIT 2 : Pulled it off. I get the record number on the database then I search within a range of record number - 2 and I find 3 elements. Then I assign < to the first one, the number of the elements to the middle one and > to the last one.

Edited April 7, 2009 by Guest