Dividing mysql result set into pages

[Anon]

I am using PHP and mysql on linux and am doing a database query.

How do we divide the whole query resultset into page segments of x records so the user can click on page 1,2,3,4 etc and directly goto any page no. ?

Pls give code examples if possible.
Thanx in advance

[Anon]

For the 10th time, Search the forum before you post.

Use the LIMIT function in your query to get pages,

LIMIT 4,9 gets 9 results starting at result 4.

[Anon]

I have tired to locate a topic with in the forum relating to this common technique I have extentsivly searched for this solution on the web lots of dead ends.

I am aware of the LIMIT 4, 9 but am still unsure about the final implementation to resolve this issue.

Perhaps some one will be so kind as to point out the obvious to Nilanjan, myself and others like us
Thanks Fru2ty

[[deleted]]

grmph

The LIMIT function can get results in chunks.
LIMIT 0,10 will get the first 10 results,
LIMIT 10,10 will get the second,
LIMIT 20,10 will get the third etc.

in short:

LIMIT ($iPageNumber*$iPageLength),$iPageLength

Now all you have to do is find a way to get $iPageNumber and send it along in your query.

You can get the total number of pages by running the query without the LIMIT and counting the results:

SELECT count(*) AS cnt
FROM table
WHERE yourstuff=here
AND foo=bar
then devide the results by the pagelength and you have the total number of pages.
you can use a simple FOR loop to print the pagenumbers and make HTML links (a href) out of them so people can click it and thereby send the pagenumber to the query.

Any clearer now?
let me know.