first 10 results then next page.......

Anon

my script pulls data from mysql database.but the thing is, it display every result at a same page..how do i get first 10 results and then print a nice button to fetch next 10 results. please send me example code if you can. thanks

lawnmowerman

Check out the article "Building Next/Prev Buttons" on this site:

http://www.phpbuilder.com/columns/rod20000221.php3

-Rich

Anon

I know Rich responded to you with an option based on a story posted here at PHPBuilder, but there are some options in addition to that one as well.

Assuming you understand the code and you're not just going to copy the code that comes with the story, I'd say do something like .....

This is psuedo code

$retid = mysql_query_db("Your query");
$howmany = mysql_get_rows($retid);

Now update your query to limit the first ten results

$your_query = $your_query." limit 0, 10";

Now, when the person clicks on the next button at the bottom of the page, you just update that limit statement in you query. The second page would look like...

$your_query = $your_query." limit 10, 10";

All the while, you use the info from $howmany to figure in the beginning how many pages you will need at 10 results per page (a simple matter of division), and of course how many results the last page will show. If you have 67 results from a query, then the query for the last page may something like...

$your_query = $your_query." limit 60, 7";

Now the reason I like this way better than the option provided by the tutorial is becuase there is a lot less tweaking of the query statement. Doing it this way, I just tack the limit statement on the end of the query as opposed to didling around with the count() stuff. It's especially problematic when you're dealing with dynamic generation of query statements.

Anyways, I know you wanted to code, but I hope this helps you think about HOW this works. That's what makes us all better developers.

Later on,
Big Din K.R.

lawnmowerman

I too have found that there are much more elegant or efficient ways to tackle certain problems depending on the situation.

Myself, I had a general idea of how to do next/prev buttons before that article was posted, but had never done it. Once I had read it (it's short and easy to follow), I had no doubt on how to do it. It was not the exact same way as the author of the article did it, but that wasn't the point. The point was that I learned by looking at a simple example and was able to come up with my own solutions for different scenarios.

Now, prev/next buttons are almost commonplace in my PHP scripts.

Good luck!

-Rich

Anon

Hey Rich,

Check this out. The first one I wrote was (and still is) a heck or a resource hog. Part of the problem was that I hadn't yet began to understand limit in SQL.

Anyways, for each page, I'd yank out ALL of the results then loop through them via mysql_fetch_array and only show those that corresponded to what was needed for the present page. Crazy ha?

Oh well, we live and learn I guess.

For now, I'd like to make a prev/next class. What do you think?

Later on,
Big Din K.R.