<?
$record = $dbA->retrieveAllRecordsFromQuery("select a.directory_id,a.directory_type,b.sub_directory_id,b.sub_directory_name FROM $tbl_Directory a right join $tbl_Subdirectory b on a.directory_id=b.directory_id where a.directory_status='Enable' order by a.directory_id,b.sub_directory_name asc");
$cnt = @count($record);
$row1= "";
$row2= "";
$row3= "";
$chkType=0;
$tmpAt ="";