using flexgrid - importing data from an sql table
I am using flexgrid, and am trying to apply it to a database of emails to list them out. To import the data into the tables currently, it uses xml, i believe. The demo file is named countryArray.inc.php. The format is as such:
- <?php
- $rows = array(
- array('iso'=>'AF',
- 'name'=>'Afghanistan',
- 'iso3'=>'AFG',
- 'numcode'=>'4',
- ),
- array('iso'=>'AL',
- 'name'=>'Albania',
- 'iso3'=>'ALB',
- 'numcode'=>'8',
- ),
How do I go from a database, to an array? Would I have to export first to a text file? Or is there another way to do this? Not sure how this exactly works.