session_start(); //if($_SESSION['login_pno']){ include '../conn.php'; function getUnit($unit){ $unite_name = "select unit from sub_unitmaster where pno_unit_code='$unit'"; $exquery = mysql_query($unite_name); $nameCader = mysql_fetch_row($exquery); return $nameCader[0]; } function getRank($unit){ $unite_name = "select rank_eng from rank_master where rank_id='$unit'"; $exquery = mysql_query($unite_name); $nameCader = mysql_fetch_row($exquery); return $nameCader[0]; } //$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 n.`employee_name`,n.`personal_number`,e.father_name, e.rank, e.unit_name FROM `training_detail` as n inner join employee_master as e on e.personal_number=n.personal_number where n.`training_code`='603' AND n.rank in ('10','1021','13','19','2','219','22','39','40','51','6','60','65','67','69','71','73','96')"); $i = 1; ?>