Datamapper and pagination

[eluser]avramovic[/eluser]
I have explained the DB structure in my first post. I have bunch of other fields in the table, but for this case I'm using only "location" as I'm trying to list all locations, display number of friends "assigned" to each location, and I need to sort locations by that number. And on top of that, I'm trying to paginate all these locations.

The project is very big and the employer is constantly adding "to-do" tasks. Listing locations in this manner was not planned when I started the project and I never intended to store locations in separate table (which would be of use now ). If I would change DB structure now, I'd have to rewrite half of my project, as there are other fields similar to "location" that need to be listed and paged :S I'm practically at the end, just need to solve this and send the employer to hell

So, has anyone tried to make "manual" pagination as I explained (or at least tried to) in my previous reply?