KoolGrid support unlimited levels of table details.
In above example, A three level hierarchy is demonstrated with Customer Master Table and two nested Detail Tables Orders and OrderDetails.
span style="color: #ff0000;">"/KoolAjax/koolajax.php";
$koolajax->scriptFolder = $KoolControlsFolder."/KoolAjax""/KoolGrid/koolgrid.php"//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
"select customerNumber,customerName,phone,city from customers"//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
"select orderNumber,orderDate,status,customerNumber from orders"//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
"select orderNumber,productName,quantityOrdered,priceEach from orderdetails,products where orderdetails.productCode=products.productCode""grid");
$grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
$grid->styleFolder="default";
$grid->Width = "655px""/KoolAjax/loading/5.gif""100%""orderNumber","orderNumber"//Auto Generate all column from tables
"orderNumber";//Disable generate column for orderNumber data fields.
"100%""customerNumber","customerNumber""customerNumber""form1" method="post"
KoolGrid - Powerful PHP GridTrialVersion 2.0.0.0 released on 2/28/2010