PHP Builder

[Gabi]

Hello,

I would like to make a fairly large dataset publicly available. The full data grid would be 9 columns wide and 100,000 rows long. In tab-delimited text file format the data would take some 7M. So instead of rendering the whole thing, I would like PHP DataGrid to show the first 100 rows of any subset of the data that the search form would turn up, but not more. Then whoever wants the data can e-mail me and I can send it as an attachment.

I understand that I cannot add a "LIMIT 1,100" clause to my main SQL statement. Is there any other way to accomplish this?

Thank you,
Gabi

[zewa666]

first of all thats the wrong board ... it should be in developers/users

next ... LIMIT is defined in Datagrid standardly ... so you simply have to set the number of rows that should be displayed. take a brief look in our wiki and the getting started section.

Greetings
Zewa