Separating results of multiple pages

[james2010]

How would I go about separating a large amount of results returned by a mysql query over many different pages? I had a few ideas but I haven't really been successful. I just need something to get me on the right track.

Thanks for your help🙂

[TodManPlaa]

Look into using the LIMIT function in your SQL statement

for example:
SELECT a,b,c FROM d ORDER BY b LIMIT 10;

returns the first ten records, while

SELECT a,b,c FROM d ORDER BY b LIMIT 11,10;

returns the next ten

etc etc

Pass your LIMIT values from page to page and you're on the right track.

Hope this helps

/s

[matjaz]

that how i do it:

1) i pass $fPage to the same script [listusers.php]
2) i do COUNT and calculate nr or records matching
3) i calculate which is 1st record [($fPage-1)*nr_or_records_per_page --- i already know how much records i want to display on the page

4) do another query with LIMIT <starting_record>,<nr_or_records_per_page>

5) display them

simple :-)

[james2010]

Thanks for your suggestions I tried them out and was able to create a much better program with query results spread over multiple pages 🙂