How can I display database query results on one page and use next button to browse more results?

MySQL's LIMIT option can be used for this. Just like you can use it to limit results, you can use it to show rows that aren't at the beginning of the result set.

For example, just adding 'LIMIT 10' to the end of a query would show the first 10 results. Appending 'LIMIT 11,10' will show 10 results, starting from the 11th, or the next 10 results. Appending 'LIMIT 21,10' will show the third set of 10, and so on.

Would I have one MySQL query that has more than one LIMIT clause, or would I have a different query that is executed on different pages? I don't understand how to use one instance of a browse/search page and provide links for the different pages of search results.

For example,

Would I have pages called search_results1.php, search_results2.php etc with a query on each that returns records using LIMIT?

Or would I make use of something similar to this:

search_results.php?username=yuyuiy&nlocation=tyutuy to use in the query but only using one search results page?

Sorry this reply is a little late.

Would I have one MySQL query that has more than one LIMIT clause, or would I have a different query that is executed on different pages?

You would use the same query, but change the parameters. See the way our Recent page works, try clicking through several pages. See the page=4 parameter? That's how Drupal works out which records to display.

It's a case of knowing how many records to display per page, then using the SQL SELECT COUNT(*) FROM tablename;, LIMIT and some maths.

Note: with LIMIT you can specify a start and an end row, for example: