import fl.controls.DataGrid;
import fl.controls.ScrollPolicy;
import fl.controls.dataGridClasses.DataGridColumn;
import fl.data.DataProvider;
import FP9.flash.com.ps.php.as3.*;
var DB_loc:String = "!--SET THE LOCATION OF YOUR DB FILES HERE--!";
var i:uint;
var totalRows:uint = 16;
var dp:DataProvider = new DataProvider();
var dg:DataGrid = new DataGrid();
//----------------------------------------
//----------BEGIN SELECT dataGrid------------------
//----------------------------------------
dataGridselect();
function dataGridselect(){
var dataGrid_table = "hello_world";
//--Array should be the table row names you wish to pull from
var dataGrid_tableRow:Array = new Array();
dataGrid_tableRow[0] = "id";
dataGrid_tableRow[1] = "message";
//where to look
var dataGrid_where:Array = new Array();
dataGrid_where[0] = "";
/*values can be = <> > < <= >= BETWEEN LIKE IN  You can put TABLE (i.e =TABLE)after any of the operators to use a table field in the what array value*/
var dataGrid_like:Array = new Array();
dataGrid_like[0] = "";
//What to look for
var dataGrid_what:Array = new Array();
dataGrid_what[0] = "";

//What to look for
var dataGrid_functionStrings:Array = new Array();
dataGrid_functionStrings[0] = "";

//orderBy and ASC arrays must have the same amount of items in the array.
//What to look for
var dataGrid_orderBy:Array = new Array();
dataGrid_orderBy[0] = "";

//What to look for
var dataGrid_ASC:Array = new Array();
dataGrid_ASC[0] = "";
var dataGrid_select:SelectDB = new SelectDB(dataGrid_table, dataGrid_tableRow, dataGrid_where, dataGrid_like, dataGrid_what, dataGrid_orderBy, dataGrid_ASC, dataGrid_returnFunction, dataGrid_functionStrings, DB_loc);
}

function dataGrid_returnFunction(vars:URLVariables, selectRows:Array, functionStrings:Array){
	var row:Object;
	dg.columns=selectRows;
	for(var i:Number = 0; i<vars.cantId; i++){
		row=new Object();
		for(var ii:Number = 0; ii<selectRows.length; ii++){
			var sr:Object = selectRows[ii];
			row[sr]=vars[selectRows[ii]+i];
		}
		dp.addItem(row);
	}
}
dg.dataProvider = dp;
dg.resizableColumns = true;
dg.move(10, 10);
dg.setSize(200, 300);
addChild(dg);
stop();