pagination by group

[Crusader]

table: lyrics
id, title, artist, album, lyrics

table: albums
id, title, year 

query: 
SELECT l.album, l.title, a.year 
FROM `lyrics` AS l, albums AS a 
WHERE l.album = a.id 
ORDER BY a.year DESC

 

My query is setup like above and I'd like to paginate the results. The problem is that I want to paginate the results AND keep results fully grouped by album. For example, I only want to get results from only the first 5 albums and paginate the rest. The way I have it now would cut results off onto the next page.

 

Any ideas on how to accomplish this?

 

Thanks

[fenway]

Sounds like you should first figure out how many lyrics per album, and then limit your query accordingly.