Next ten records

Anon

Dear,

The result of one of my select queries is a page of over a 100 records, obviously I don't want my page to keep on loading and getting endlessly long, therefore : whom of you knows a bit of php script to spit the result of a select query into bits ? (lets say for example, ten records per page.)

It would really help me !

Thx
Joris

Anon

In your inisital query that gets the 100 results, use the LIMIT clause to
find the first 10 answers, or the next 10:

SELECT * FROM table WHERE something=something_else LIMIT 0,10;

for the first ten,

SELECT * FROM table WHERE something=something_else LIMIT 10,10;

for the next ten, ect ect

If your query is very slow, you may have to go for a more complex solution
where you store all the results in a new temporary table, from which you can then select using the limit clause.

Anon

I have implemented this storing all the data in the client (in an array var.) which holds the 100 records.
Arrays in client variables can even be a lot bigger.

The problem with the LIMIT function, is that you will do multiple acceses to your database, and in case your db is accessed by many users, each user will do a 'hit' to the db for each 10 records he needs.

If you store the 100 records in an array in the client, you will transfer them almost as fast as the 10 you did with the LIMIT function, and you may easily select 10 by 10 from the local array without accessing the database any more.

you may check http://www.phpbuilder.com/columns/rod20000221.php3
for the PREV/NEXT scripting ideas, and implement it your way.

Good luck,

YskZ!

Anon

How do you store the array at the client? you just download all the data to the client browser?

Anon

You can have a class (public require'able file) where you do the select.. database connection open & close.. and all that, and that function may return a $variable, which is an array, and this way you receive the variable in your .php code, and this var. is the array you´ll be displaying.

you should also store the array in the session object, so you won´t loose it while paginating or so.

I hope this gives you an idea to solve problem, if you need some help, just post it here, (or code!)

YskZ!

Anon

Along the lines of a "Go to next 10 records..." link, I wanted to break up my 150 record result table into tables of like 25 results. I had the code doing that fine, but I could not for the life of me get the tables to be of uniform size. I have tried CSS and fixed column widths, but I guess my HTML is really not that exception. This isn't really on tapic database stuff, but can anyone give me a few tips on how to make the tables of unform size? The table with all 150 records takes too long to load.

Thanks

Anon

Aha, so you store it on the server. That makes more sense :-)

Anon

Make sure your table/cell width is not set smaller than the max-length of what you put in.

If you define an html column to be 100 pixels wide, and you put 200 pixels worht of text in, the column is resized to 200 pixels.