RE: [PHP] Previous & Next Navigation

[snip] Okay...glad to see someone put some thought into it instead of just wanting to do it because "queries are bad!". Also, the speed of the query doesn't depend on the connection speed at all. [/snip] I know...in this case it is just the number of records that are needed vs. the number of records in the table. [snip] Or maybe you could load the results into a temporary table and do the subsequent paging out of that table (which will be faster, only having 3-5K rows). run a cron job to delete temp tables after the are X minutes old, etc... [/snip] This is where I am leaning right now, the LIMIT query would be much faster than an array if this is the case. Thanks John! Jay