multiple pages for results...

[ronjon]

can anybody give me a brief conceptual idea of how to make my results show up in multiple pages. you know... like when you do a search on google... you have the pages on the bottom that you can choose to jump to. like...as in...would i use session variables to keep the sql statement and filter through the result by using url passed variables with the page number links...

i really have no clue as to where to start... somebody give me a hand?

thanks in advance.
ron

[richblend]

you should have a start and end position. pass them in the URL, like this..

search.php?start=21&end=40

take your resultset as usual, and loop through it to display the search results. However, use if statements, so that for the first 20 results in teh resultset, dont print them. Everything after 40, dont print that either. Then if you have next and prev buttons, you just increase these numbers... so that the "next" button, would link to...

search.php?start=41&end=60

this will show 20 results at a time.

$n=0;
while($row=mysql_fetch_array($resultset)){
    if ($n > $start && $n < $end){
        print $array['something']."<br />";    

    }
    $n++;
}

[Weedpacket]

Also, search the forums for "pagination". That's what it's called. It's also in the FAQ. Did you look there?