='".$start_date."' "; $qry_date.=" and b.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') "; } $query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where bp>130 and patient_id in ($query1) $qry_date"; // echo $query; $result = @mysqli_query($conn,$query); ?>

0) { if ($row = @mysqli_fetch_assoc($result_result)) { $percentage=($rowOfEmployee['total']/$row['total_active'])*100; ?>

SPO2 Severity	No. of Patient	%
Run Date :	Covid SPO2 Severity	User :
		%
Total		%