how do you display multiple pages of mysql data in Modx

I just about got my site up and running which has a lot of static pages made up of lists. I would like to make these into a database and have it display a certain number of lines, then have a menu that displays [prev 1 2 3 4 5 6 next] to display the rest of the pages. Is this possible in modx as I’ve searched the wiki and this forum with no results?

You have static pages made up of lists? Can you give an example of what you mean? Or does that even have anything to do with what you are wanting?

There is a handy snippet called loopDBchunk that will do this natively. Not sure if it is in the resources or in the forum, best do a search and see what shows up.

Well I’m working on a genealogy website which has listings of cemetery burials. I have the listings divided into several pages but was wanting to use php and mysql to make a database and use that to populate the pages but with the ability to have the query only display a certain number of burials as having over 500 names display on one page doesn’t make since. Then be able to have a menu system to bring up a new page with the listing continuing. If I do it just using documents I’m looking at over 500 documents

Here is the link to my site. Maybe this will give you an idea as to what I’m trying to do.

http://www.charlottegenealogy.com/cemeteries/carl-bailey/carl-bailey-a-d.html

Sounds like you could use an Ajax datagrid.

Here’s a nice tutorial.

There are a few already built, like http://www.gurusistemas.com/indexdatagrid.php and http://www.weberdev.com/get_example-4611.html.

I used one for my demo module tutorial, http://sottwell.com/database-module-2.html