Persistent result cursors?

[lawnmowerman]

Try using code like this:

<?php
if( ! isset( $index ))
$index = 0;

$query = "SELECT * FROM table LIMIT $index,20";

$result = mysql_query( $query );
?>

This LIMIT clause tells the SQL server to return 20 rows, starting at row $index. Please note that rows start at 0, not 1.

http://www.mysql.com/doc/S/E/SELECT.html

Hope this helps!

-Rich

[Anon]

I am trying to improve the performance of my web page (and myself). I have a page that retrieves all of the rows from a mysql table (select from table). I do not want to show all the results because it would be too long, so I split them up into pages of 20 rows. If I want to show the next 20, the page calls itself but with a new value that specifies the number of rows to offset (i.e. results.php?index=20). The problem is that the server will execute the same query (select from tables). I do not want to perform the same query twice, since I already have a complete record set from the first time the page was loaded. Can I use sessions to save the result set?