[thelist] PHP Previous Next Navigation

[Michael Mell]

Given the <30K size of data, I would create form with hidden fields to contain
the data of all 5000 records and a hidden field indicating the currently
displayed count. Hitting "Next" submits the form, and PHP will display the
desired next 30 records.

You'll have to create your own format for organizing the data in the form. I
would avoid xml because of the overhead of creating the files and parsing and
general lack of usefulness in such a situation.

I don't know of a script you can grab, but it should be pretty easy to code up.

hth
m

Jay Blanchard wrote:

> Simon,
>
> [snip]...stuff about MySQL LIMIT...[/snip]
>
> Thank you for your information. I am aware of and have used LIMIT for many
> queries in MySQL, but there is a problem here that I probably have not been
> clear enough about. These 3000-5000 records exist in a table that has
> millions of records. So for each query with LIMIT MySQL has to traverse all
> of the records right up until it receives the limit amounts back The further
> into the table you go, the worse the delay. The array, if I built one from
> the desired records, would take up less memeory space than most front pages
> on web sites (under 30k), making it rather quick on subsequent "pages". I
> know how easy it is to do this with LIMIT and I wish that I could take
> advantage of it. But I am afraid that speed is the largest issue at this
> point.
>
> Thanks!
>
> Jay
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !

--
mike[at]nthwave.net
llemekim         YahooIM
415.455.8812     voice
419.735.1167     fax