> I need to search a table and find a specific record. This I can do,
> altho I then need to find 49 people either side of this record when
> ordered by rank.
>
> I.e I have loads of people who are ranked. Want to choose a player and
> then find the people either side of that player.

Sounds like a job for the HANDLER statement:

http://dev.mysql.com/doc/refman/5.1/en/handler.html

Best regards,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/