session_start(); include("../conn.php"); $rs = mysql_query('select distinct subunit_name,subunit_code from nondef where unit_name = \''.$_REQUEST['id'].'\' order by subunit_name'); $rs1 = mysql_query("select Distinct pno_unit_code from SUB_UNITMASTER as s,range_master as r where s.unit=r.district_name_eng AND unit='".$_REQUEST['id']."'"); $t=mysql_fetch_array($rs1); ?>
if(mysql_num_rows($rs) > 0) { ?> } else {?> No sub unit defined for this unit. } ?>