Seperating by number of rows

[sp@rky13]

What I want do is basically show the first 100 results (rows) in one place on a page and then the next 100 on the next and so one. how can this be done. So I started with this. Not sure if it helps or not but oh well. So find the number of rows and set variable:

$numrows =  mysql_num_rows($result);

 

and then I would think all I would have to do is some how do something like maybe variable a ($a) would have the first 100 rows and then variable b ($b) would have the next 100. Is this at all possible? It doesn't have to use the variables, I just though that that might explain it

[xtopolis]

CV wrote a nice tutorial just for you on Pagination.  It should have all the answers you need.

[sp@rky13]

Thank you. I don't have time as it's lunch time now to read it but I will read it later

[sp@rky13]

Ok a very stupid question I would think but I just can't find how to do it in the tutorial. I'm very likely missing it lol. Anyway, looking through the tutorial, I see that it has this:

 

   // echo data
   echo $list['id'] . " : " . $list['number'] . "<br />";

 

which is where i would put my echo command obviously but I can't find where I would put the actual query. I know it's there somewhere but I can't find it in the tutorial/code