session_start(); //if($_SESSION['login_pno']){ include '../conn.php'; if(!empty($_REQUEST['cadre'])) { $cadre=$_REQUEST['cadre']; } if(!empty($_GET['num'])) { $dist=$_GET['num']; } if(!empty($_GET['r_id'])) { $r_id=$_GET['r_id']; } //$result = mysql_query("select e.personal_number,r.rank_eng,e.first_name_of_employee_english from employee_master as e inner join new_posting_detail n on n.personal_number=e.personal_number where n.joining_unit='$dist' or n.joining_sub_unit='$dist' group by e.rank"); //echo "select e.personal_number,e.first_name_of_employee_english,e.last_name_of_employee_english,e.middle_name_of_employee_english,e.joining_date,e.father_name,e.date_of_birth from employee_master as e inner join new_posting_detail n on n.personal_number=e.personal_number where( n.joining_unit='$dist' or n.joining_sub_unit='$dist') AND e.rank='$r_id' and e.cadre='$cadre'"; $result = mysql_query("select e.personal_number,e.first_name_of_employee_english,e.last_name_of_employee_english,e.middle_name_of_employee_english,e.joining_date,e.father_name,e.date_of_birth from employee_master as e inner join new_posting_detail n on n.personal_number=e.personal_number where( n.joining_unit='$dist' or n.joining_sub_unit='$dist') AND e.rank='$r_id' and e.cadre='$cadre'"); $result1 = mysql_query("select unit from sub_unitmaster where pno_unit_code='$dist' limit 1"); $result2 = mysql_query("select rank_eng from rank_master where rank_id='$r_id'"); $i = 1; ?>