='".$start_date."' ";
$qry_date.=" and medical_entry_date >=str_to_date('".$start_date."','%d-%m-%Y') ";
}
if(isset($end_date) && $end_date!=''){
//$qry_date.=" and checkup_date <='".$end_date."' ";
$qry_date.=" and medical_entry_date <=str_to_date('".$end_date."','%d-%m-%Y') ";
}
$i=0;
$record =array();
/* starting from 18 to 25 */
$query1="select id FROM patient_master where YEAR(CURDATE())-year(doj)>=0 and YEAR(CURDATE())-year(doj)<2 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
//echo $query;
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
$result = mysqli_query($conn,$query);
//echo $query;
?>
=2 and YEAR(CURDATE())-year(doj)<5 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
//echo $query;
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(2-5)
Patient Name
=5 and YEAR(CURDATE())-year(doj)<10 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
// echo $query;
//echo $query;
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(5-10)
Patient Name
=10 and YEAR(CURDATE())-year(doj)<15 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(10-15)
Patient Name
=15 and YEAR(CURDATE())-year(doj)<20 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(15-20)
Patient Name
=20 and YEAR(CURDATE())-year(doj)<25 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(20-25)
Patient Name
25".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name,GROUP_CONCAT(DISTINCT past_present_illness SEPARATOR ',') as illness from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where patient_id in ($query1) $qry_date group by patient_id Having Find_In_Set(2,illness)>0";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>