Spliting the Result of a query in Pages

marsupillami

I have a query, that gives me about 60 results. I wanted to split these results in 20 per page. How can that be done? At the end there would be the pages in this format, (example)

1-20 | 21-40 | 41 - 60 .....

Could you please help me?

Thank you.

ziesje

You can use the LIMIT function in your (my?)SQL query.

SELECT .... blablalbla ... LIMIT 0, 19 for the first 20 results.

For more details see :

http://www.mysql.com/doc/en/SELECT.html

marsupillami

Yes, it´s MySQL. That would give me the first 20 lines, right? And what about the next ones?