Pagination Function

[FishSword]

Hiya!

 

How do I create a pagination function that can be used multiple times, with any MySQL query?

 

Many Thanks,

 

[Rifts]

http://tinyurl.com/367zxfw that might help

[Oziam]

There is also a cool class at PHP Classes called CSS Pagination, it can be easily included with multiple queries and styled to suit any site!

[FishSword]

Is it possible to make/use a function to paginate results, rather than a class? If so, how?

[fortnox007]

Is it possible to make/use a function to paginate results, rather than a class? If so, how?

I am still to php, but maybe assign a select query with a limited range to the buttons depending on the amount of rows. I bet you need to use a query like:

SELECT * FROM content LIMIT 0,9  (button 1)

SELECT * FROM content LIMIT 10,19 (button 2)

et cetera.

And before that use count the rows of the table and divide them. But i should have a look into this myself too. But this makes sense to me