if ($gDB) { $arr = $gDB->MetaTables(); } print PHPLensArrayMenu('table2 onchange=fetchtable2() ', $arr, true, $lens_qb_detail, false); ?> </td><td width=50%> Foreign Key <?php if ($gDB) { $colarr = $gDB->MetaColumns($lens_qb_detail); } if ($colarr) { $arr = array(); foreach ($colarr as $k => $v) { $arr[] = $k; } print PHPLensArrayMenu('col2 onchange=fetchtable2() ', $arr, true, $lens_qb_detail_key, false); } ?> </td></tr> </table> </FORM> <?php if (!empty($lens_qb_master) && !empty($lens_qb_master_key) && !empty($lens_qb_detail) && !empty($lens_qb_detail_key)) { print "<a href=masterdetail2.php?table={$lens_qb_master}>Generate Master Detail Code</a>"; } ?> </body> </html>
<table border=0 width='100%'><tr><td> <FORM name=gettable> <b>Table</b> <?php if ($gDB) { $arr = $gDB->MetaTables(); } print PHPLensArrayMenu('tables onchange=fetchtable() ', $arr, true, false, false); ?> </FORM> </td><td> <FORM name=getdriver> <b>Database</b> <?php $arr = array(); foreach ($PHPLENS_DATABASES as $k => $v) { $arr[] = $k; } print PHPLensArrayMenu('drivers onchange=fetchdb() ', $arr, false, $lens_qb_drivername, false); ?> <a href=sql.php target=_top><b>SQL Tool</b></a> </FORM> </td><td align=right> <form> <a href=confighelp.html target=_confighelp>Builder Help</a> </form> </td></tr> </table> </body> </html>