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
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