Pages

Subscribe

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

http://www.akemapa.com/2008/07/15/php-mysql-select-previous-row-and-next-row-from-current-id/

No comments: