Re: How to query for 25 records before and 25 records after a record alphabetically

2003-11-03 Thread gerald_clark
ORDER BY and LIMIT. Jeremy March wrote: I have an alphabetic list of records in a table and I want to display the 25 previous and 25 next records before and after a selected record. This would be easy if "before" and "after" meant sorted by id number, but I need it sorted alphabetically. Doe

How to query for 25 records before and 25 records after a record alphabetically

2003-11-03 Thread Jeremy March
I have an alphabetic list of records in a table and I want to display the 25 previous and 25 next records before and after a selected record. This would be easy if "before" and "after" meant sorted by id number, but I need it sorted alphabetically. Does anyone know a good way to do this? Than