I am trying to apply a pagination effect but show all the results on a single page. sometimes the results can go as high as 500 records.
First Idea:
run my php/mysql query. Load the results into an array and "Render/Echo" the results in small increments to page. My goal is show a few results at time.
Second Idea:
run smaller queries based on the mysql limit count ie:
query 1
select rows from table limit 50
query 2
select rows from table limit 51, 50
query 3
select rows from table limit 101, 50
etc ............
Hopefully you get the picture .... The above two are my ideas. But I am open to some other suggestions.
thanks
Btw - what I am doing currently is calling the onLoad function in javacript and running two seperate javascript/php functions using (xmlHTTP) that populates two separate Divs one after the other. This works. But if that second Div has a large recordset (i.e more than 150 rows) the results takes a while to render out.
