Could somebody give me a hint how to create next/previous records as follows:
When I display the full page with a record's content I would like to have at the bottom of the page the next/previous records of this one according to sorting by a specific field of the record.
I have done this with two MySql queries using asc/desc so I can locate the next record, however I think it could be done without all this extra code making the page load faster. What I cannot figure out is how to query the previous row while making the specific sorting.
Thanks in advance for any suggestions.
