Web Development

I have a project to migrate my club's membership database from Access to web based using MySQL/PHP, but I have a problem I can't get my head around and would appreciate some help...
Background...
I want to be able to display each member's data on screen and add a Previous and Next button to move the display to the next member in the list, with an order based on member's LastName, FirstName (and some other fields).
Creating the order to display is easy..

Code:

select MemberId
from Member 
order by LastName, FirstName, Title, MemberId

and then I can display a specific record with

Code:

select * from Member where MemberId=<...>

...but how do I determine the member ID for the next record when I'm displaying one record. So, if I'm, say, 30 records in, how do I know the Member ID of the 29th (previous) and 31st (next) record.

To clarify, let's assume that the sorted MemberId order is

Code:

17
25
8
42
40
...

Assuming I'm displaying the values of ID=8 on the page, what do I need to compute to enter 25 in the previous button and 42 in the next?

Hope that's clear.

Check out the LIMIT clause. See the MySQL documentation for details.

That might do the trick - thanks.