How to get next and prev records in mysql

From http://stackoverflow.com/questions/1446821/how-to-get-next-previous-record-in-mysql