[BNM] Moving to next record in MySQL

[delarge]

Hi hey yo

I wondered if there is a way to do this in MySQL...
Say I pick the latest id like SELECT * etc. LIMIT 1

and that has an id of 1325 for example...
so we have a url like:
site.com/?id=1325

now on the next page I want to select the next record down, regardless of
its id - so it might be 1287, not neccessarily 1325 -1...

I know you can do an offset kind of thing like this:
ORDER BY id DESC LIMIT 5, 1

But I don't think that would help...
Am I making sense?  Can anyone help?

--
Paul Burgess

iampaulburgess.co.uk
delarge.co.uk
urbandirty.com