Flexigrid - Lightweight but rich data grid

[eluser]paulopmx[/eluser]
[quote author="millercj" date="1207203552"]Ok so now that i understand this a little better I've been working on trying to create something similar to the Example 3. I'm getting my data from a SQL database and processing through a file, post.php (like shown on the site) I'm getting my data as expected from by DB echoing from the php as XML.

The example shows how to use JSON but now do I use XML/SQL, this is what i've adapted from the JSON example but it just gives me a blank white screen

Code:

$(".flexme").flexigrid
            (
            {
            url: 'post.php',
            dataType: 'xml',
            colModel : [
                {display: 'id', name : 'id', width : 100, sortable : true, align: 'left'},
                {display: 'fname', name : 'fname', width : 100, sortable : true, align: 'left'},
                {display: 'lname', name : 'lname', width : 100, sortable : true, align: 'left'},
                ],
            buttons : [
                {name: 'Add', bclass: 'add', onpress : test},
                {name: 'Delete', bclass: 'delete', onpress : test},
                {separator: true}
                ],
            searchitems : [
                {display: 'ISO', name : 'iso'},
                {display: 'Name', name : 'name', isdefault: true}
                ],
            sortname: "lname",
            sortorder: "asc",
            usepager: true,
            title: 'Directory',
            useRp: true,
            rp: 15,
            showTableToggleBtn: true,
            width: 700,
            height: 200
            }
            );

[/quote]

Go back to the site http://webplicity.net/flexigrid, click How to use, then there is a link there called Show Sample PHP code for XML.