Tuesday, August 25, 2009

Getting next and previous rows in MySQL

I was having a problem getting next and previous row IDs from a MySQL database, it's easy to add 1 or delete 1 but what if there's a missing ID # because an item had to be deleted.

Well here's the right way to do it

No comments: