I am trying to fill the data grid component from Tim K Chung, with values coming from my SQL server...
Flash code:
rc = new RecordSet(["ID","firstname", "midname", "lastname"]);
loadVariablesNum ("Grid.php?AantalRijen="+AantalRijen, "0");
for(i=0;i<=AantalRijen;i++){
loadVariablesNum ("Grid.php?Thefirstname[i]="+Thefirstname[i]+"&Themidname[i]="+Themidname[i]+"&Thelastname[i]"+Thelastname[i]+"&TheID[i]="+TheID[i], "0");
rc.addItem({ID:TheID[i], firstname:Thefirstname[i], midname:Themidname[i], lastname:Thelastname[i]});
}
This doesn't work

With this PHP code:
<?php
// Variabelen
require 'include.php';
// Inloggen database
$conn=mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db("$DBName");
if(mysql_errno()){
echo mysql_errno().": ".mysql_error()."\n";
exit;
}
$result = mysql_query("SELECT *FROM $table");
$numRows = mysql_num_rows($result);
print "AantalRijen=$numRows&";
while($Namen = mysql_fetch_row($result))
print "TheID[$Namen[0]]=$Namen[0]&Thefirstname[$Namen[0]]=$Namen[1]&Themidname[$Namen[0]]=$Namen[2]&Thelastname[$Namen[0]]=$Namen[3]";
mysql_close($conn);
?>
I don't think this is the fastest way reading value for value...
Does somebody know a fast way to fill the grid with arrays?
Thanx!!!