Adding pagination

Surely I'm not the only one that has a nightmare when it comes to adding pagination to my modifications..

Does anyone have any tips on how to do this? Everything I try seems to result in some kind of error, or unwanted result. I've attached one mod that I would like to add pagination to, pointers please..? :nervous:

[Oblivion Knight]

^ Bump..
Desperately trying to learn this.. I'm not brilliant with MySQL stuff yet. :bored:

I had another attempt at this today, and I've limited the list of users shown to a set number, but can't get the page numbers to show to display another list of users on a second page..

[Dean C]

Pagination is a pain in the ....

I'd recommend looking at the code in memberlist.php and what they use for their pagination. That's how I learnt

- miSt