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..
select MemberId
from Member
order by LastName, FirstName, Title, MemberId
and then I can display a specific record with
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
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.