//echo 'THE VALUE OF UNIT'.$_POST['dist'];
//echo 'THE VALUE OF SUB UNIT'.$_POST['unit'];
/*if($_POST['dist'] == "1")
{
$query="SELECT personal_number, `first_name_of_employee_english` , `father_name` , `date_of_birth` , `rank`,
".$_POST['crit']." FROM employee_master WHERE ".$_POST['crit']."='' OR ".$_POST['crit']." IS NULL
AND `personal_number` IN (SELECT distinct`personal_number` FROM `new_posting_detail` WHERE `joining_unit` AND `joining_sub_unit`)";
}
else
{
if($_POST['unit'] == '1')
{
$query="SELECT personal_number, `first_name_of_employee_english` , `father_name` , `date_of_birth` , `rank`,".$_POST['crit']." FROM employee_master WHERE ".$_POST['crit']."='' OR ".$_POST['crit']." IS NULL AND `personal_number` IN (SELECT distinct`personal_number` FROM `new_posting_detail` WHERE `joining_unit`='".$_REQUEST['dist']."' AND `joining_sub_unit`)";
}
else
{
$query="SELECT personal_number,`first_name_of_employee_english` , `father_name` , `date_of_birth` , `rank`, ".$_POST['crit']." FROM employee_master WHERE ".$_POST['crit']."='' OR ".$_POST['crit']." IS NULL AND `personal_number` IN (SELECT distinct`personal_number` FROM `new_posting_detail` WHERE `joining_unit`='".$_REQUEST['dist']."' AND `joining_sub_unit`='".$_REQUEST['unit']."')";
}
}
*/
if($_POST['dist'] == "1")
{
$query="SELECT e.personal_number, e.first_name_of_employee_hindi, e.fathers_name_hindi, e.date_of_birth, e.rank,e.caste,e.".$_POST['crit'].", n.joining_unit, n.joining_sub_unit ,e.joining_date FROM employee_master AS e INNER JOIN new_posting_detail AS n ON e.personal_number = n.personal_number WHERE (e.".$_POST['crit']." = '' OR e.".$_POST['crit']." = '0000-00-00') AND e.personal_number IN ( SELECT DISTINCT n.personal_number FROM new_posting_detail AS n WHERE n.joining_unit AND n.joining_sub_unit AND n.type_of_joining) ORDER BY e.personal_number";
}
else
{
if($_POST['unit'] == '1')
{
$query="SELECT e.personal_number, e.first_name_of_employee_hindi, e.fathers_name_hindi, e.date_of_birth, e.rank,e.caste, e.".$_POST['crit'].", n.joining_unit, n.joining_sub_unit,e.joining_date FROM employee_master AS e INNER JOIN new_posting_detail AS n ON e.personal_number = n.personal_number WHERE (e.".$_POST['crit']." = '' OR e.".$_POST['crit']." = '0000-00-00') AND e.personal_number IN ( SELECT DISTINCT n.personal_number FROM new_posting_detail AS n WHERE n.joining_unit='".$_REQUEST['dist']."' AND n.joining_sub_unit) ORDER BY e.personal_number";
}
else
{
$query="SELECT e.personal_number, e.first_name_of_employee_hindi, e.fathers_name_hindi, e.date_of_birth, e.rank,e.caste,e.".$_POST['crit'].", n.joining_unit, n.joining_sub_unit,e.joining_date FROM employee_master AS e INNER JOIN new_posting_detail AS n ON e.personal_number = n.personal_number WHERE (e.".$_POST['crit']." = '' OR e.".$_POST['crit']." = '0000-00-00') AND e.personal_number IN ( SELECT DISTINCT n.personal_number FROM new_posting_detail AS n WHERE n.joining_unit='".$_REQUEST['dist']."' AND n.joining_sub_unit='".$_REQUEST['unit']."') ORDER BY e.personal_number";
}
}
echo $query;
$empquery=
mysql_query($query) or die(mysql_error());
echo 'TOTAL RECORD IS:'.mysql_num_rows($empquery);
$i=1;
while($row=mysql_fetch_array($empquery)){?>
//
--
---
---
--
//
$i++?>
}
if($i==1)
{
echo "
No Record Found
";
}
?>
echo 'TOTAL RECORD IS:'.mysql_num_rows($empquery); ?>