How to: Pagination with PEAR::DB

Hi,
I'm trying to make a search page which will find some data from a db. But I can't get all the data to one page. So I should make a pagination. I'm using pear's DB, and I'm a little confused with it's functions. Is there a tutorial or a documentation that I can read about this? Or a better alternative can you explain me ?

And by the way should I pass to pear's MDB2 from DB? And is there is simple tutorial for that one too?

Thank you for your time.

There is a tutorial on how to paginate using PEAR:B and some help if you search the forums. (but you will need to use the LIMIT statement in your SQL syntax to accomplish this)

I believe PEAR::MDB2 allows for retrieving all the rows at once and then diplaying the number of rows you wish at a time. (Note: you will still need to use php if you wish to alternate row colors)

See example 33-4 on the PEAR:MDB2 website for syntax. I would like to see a tutorial on MDB2 if someone has the time to write one.

I suppose if you're starting from scratch you should choose PEAR::MDB2 since PEAR:B is no longer being developed (no new features, just bug/security fixes).

Duane