Well, since we can't persuade you to help, I looked at the code again with a fresh mind today, and I figured it out on my own.

As I stated in my initial post, it sure would be nice if you would actually allow people to read the PHP you are using on your demo page.

Without being able to read the PHP we are left strictly guessing from seemingly incorrect documentation!

Also, I just noticed that the documentation for the PHP file appears to be incorrect as well. It shows these elements in the generated XML:

records: the total records from the query

total: the total pages in the query

In the sample code on the same page, they show:

$s .= “” . $count . “”;

$s .= “” . $total_pages . “”;

But in this forum post, I was instructed to swap these values like so:

$s .= “” . $totalpages . “n”;

$s .= “” . count ($rows) . “n”;

This worked, in that it caused jqGrid to start loading as needed, but the grid still stops at 400

One last question:

If I change the index.js rowNum: argument to 1000, the grid only loads the first 1000 rows. Is there something else I need to change to make it support loading 1000 rows at a time, or is it limited to auto-loading only 100?

Wow… This forum really screws up pasted code!

So if you want to see the actual code, here is an archive of it – I included a mySQL dump of the actual database being queried as well:

grid_test.zip

The first person to tell me what is wrong with the code gets a gold star.