0;$i--){ $query="SELECT COUNT(appointment_id) as count,date(NOW()-INTERVAL $i DAY) as date FROM employee_appointment WHERE DATE(appointment_date) = date(NOW()-INTERVAL $i DAY) AND APPOINTMENT_TYPE='O';"; if (!$result = @mysqli_query($conn,$query)) { exit(mysqli_error($conn)); } if(mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { array_push($xaxis,date('d-m-Y',strtotime($row["date"]))); array_push($opd,$row['count']); error_log('dd'.$row["date"]) ; } } } for($j=15;$j>0;$j--){ $query2="SELECT COUNT(appointment_id) as count,date(NOW()-INTERVAL $j DAY) as date FROM employee_appointment WHERE DATE(appointment_date) = date(NOW()-INTERVAL $j DAY) AND APPOINTMENT_TYPE='O' and ailment_systems_new='1'"; if (!$result2 = @mysqli_query($conn,$query2)) { exit(mysqli_error($conn)); } if(mysqli_num_rows($result2) > 0) { while ($row2 = @mysqli_fetch_array($result2)) { array_push($xaxis2,date('d-m-Y',strtotime($row2["date"]))); array_push($opd2,$row2['count']); error_log('dd2'.$row2["date"]) ; } } } for($j=15;$j>0;$j--){ $query3="SELECT COUNT(e.appointment_id) as count,date(NOW()-INTERVAL $j DAY) as date FROM employee_appointment e left join patient_master p on e.emp_id=p.id WHERE DATE(e.appointment_date) = date(NOW()-INTERVAL $j DAY) AND e.APPOINTMENT_TYPE='O' and p.designation_id='38'"; if (!$result3 = @mysqli_query($conn,$query3)) { exit(mysqli_error($conn)); } if(mysqli_num_rows($result3) > 0) { while ($row3 = @mysqli_fetch_array($result3)) { array_push($xaxis3,date('d-m-Y',strtotime($row3["date"]))); array_push($opd3,$row3['count']); error_log('dd3'.$row3["date"]) ; } } } ?>