Chose next value in database

treeleaf20

All,
If I have the following IDs:

6, 7, 9, 15, 20 etc.

If I'm on 20, how do I select the next lowest ID in this case 15?

If I get all the way to 6 and that is the lowest ID in the database, how do go back to the greatest one in the database?

I'm going to use these as links like Previous Next links.

Thanks in advance.

djjjozsi

under:

select idfield from your_table where idfield<$actual$id LIMIT 1

above:

select idfield from your_table where idfield>$actual$id LIMIT 1

when you make the links, you can select the next and previous ID's.

treeleaf20

That's a start but that can pick any one that is less or greater. How can I find the next lowest one or next highest one?

laserlight

treeleaf20 wrote:
That's a start but that can pick any one that is less or greater. How can I find the next lowest one or next highest one?

Order by the ID. This technique for a scrolling cursor is described in Scrolling Cursor. The article is SQLite oriented, but the idea (and even SQL) is broadly applicable.