Top/bottom pages

The idea of paging content up and down: you specify an ID (current, for example, 10) & nbsp; the previous page is smaller than 10 and the largest. As long as you get 10 smaller and the largest. The next page is 10 largest and the smallest. Please help us with code support. selectidfromtablewhereid & gt; the current IDlimit0, 1; s content is paginated up and down
Ideas:
You specify an ID (current, for example, 10)
The previous page is smaller than 10 and the largest. As long as you get 10 smaller and the largest.
The next page is 10 largest and the smallest.

Please help me with code support

------ Solution --------------------
Select id from table where id> current ID limit 0, 1;
Select id from table where id <Current id limit 0, 1;
------ Solution --------------------
Select id from table where id> current ID order by id asc limit 1; // Next
Select id from table where id <Current id order by id desc limit 1; Next

The next step is simple.