Get previous & next id value of mysql query

Get previous & next id value of mysql query

References

Reference NO 1

http://stackoverflow.com/questions/1081851/mysql-query-to-get-previous-and-next-video-id

Reference NO 2

http://stackoverflow.com/questions/4096420/mysql-query-get-the-next-or-previous-item-when-list-is-sorted-using-value-that

Reference NO 3

http://php.net/manual/en/function.mysql-insert-id.php

Reference NO 4

http://forums.phpfreaks.com/topic/165164-mysql-query-to-get-next-previous-id/

Reference NO 5

http://www.codingforums.com/archive/index.php/t-94437.html

Reference NO 6

http://www.scottklarr.com/topic/111/how-to-select-previousnext-rows-in-mysql/

Reference NO 7

http://www.tutorialspoint.com/mysql/mysql-select-query.htm

Reference NO 8

http://www.barricane.com/2012/02/08/mysql-select-last-matching-row.html