[Resolved] return next page of results

[dougal]

I've got my (MySQL) databases and access pages / forms working fine ... took ages but they're there (e.g http://www.aeromedical.org/Search/avmed_bibliosearch.php).

I'd like to modify my results pages so that, when the number of hits is large, only a small number (say 25) are shown and a button offers to show the next 25 when clicked. At the moment I simply limit the number of loops through the sorted 'mysql_fetch_array' result.

I can build the tools but am not sure of the structure and logic I need to apply. Do I need to search again and simply start my results looping out from a different spot or can I get back and access the original result set? Any examples you can direct me to where I can see this sort of structure?

Hope the questions aren't too stupid, and make a little bit of sense.

Cheers
Dougal

[yelvington]

Use the LIMIT clause in SQL. Search the forums AND the tutorials for "pagination" for many examples.

[dougal]

Use the LIMIT clause in SQL. Search the forums AND the tutorials for "pagination" for many examples.

Thanks. I already use LIMIT to keep the numbers down but it does sound like 'pagination' is the key concept I need to learn more about for this.

Cheers
Dougal