[RESOLVED] Determine Next and Previous Entry

[xxdalexx]

The way the table is set up is that there is an ID column thats set on auto increment. How would I go about designing next and previous record links where it finds the id number of the next and previous record, because I cant do a basic math to add or subtract one in the case that the record was previously deleted.

Thanks for the help.

[dagon]

one option:

Previous ID:

SELECT id FROM $mytable WHERE id < $id ORDER BY ID DESC LIMIT 1;

Next ID:

SELECT id FROM $mytable WHERE id > $id ORDER BY ID ASC LIMIT 1;

[xxdalexx]

Thank You.