$i=1;
$query= "SELECT a.personal_number,concat_ws(' ',a.first_name_of_employee_english ,a.middle_name_of_employee_english, a.last_name_of_employee_english) as employeeName ,a.father_name,a.date_of_birth,a.joining_date_presnetRank,a.rank,b.joining_unit,b.joining_sub_unit ".
"FROM employee_master AS a,new_posting_detail AS b ".
"WHERE b.joining_unit!=b.joining_sub_unit and b.joining_unit!=0 and b.joining_sub_unit!=0 and a.personal_number=b.personal_number AND a.rank = '".$_REQUEST['rank']."' order by joining_date_presnetRank ,joining_unit,joining_sub_unit" ;
$strArr=mysql_query($query) or die("Error in query = ".mysql_error());
while($row=mysql_fetch_array($strArr)){
?>