0) { while ($row = @mysqli_fetch_array($result)) { array_push($xaxis,date('d-m-Y',strtotime($row['date']))); array_push($opd,$row['count']); error_log('yy'.$row['date'].'ccc'.$row['count']) ; } } $query2="SELECT COUNT(appointment_id) as count,date(NOW()-INTERVAL ($i*7) DAY) as date FROM employee_appointment WHERE DATE(appointment_date) BETWEEN date(NOW()-INTERVAL ($i*7) DAY) and date(NOW()-INTERVAL (($i-1)*7) DAY) AND APPOINTMENT_TYPE='O'and ailment_systems_new='1'"; error_log('yy'.$query2) ; 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']); } } $query3="SELECT COUNT(e.appointment_id) as count,date(NOW()-INTERVAL ($i*7) DAY) as date FROM employee_appointment e left join patient_master p on e.emp_id=p.id WHERE DATE(e.appointment_date) BETWEEN date(NOW()-INTERVAL ($i*7) DAY) and date(NOW()-INTERVAL (($i-1)*7) DAY) AND e.APPOINTMENT_TYPE='O'and p.designation_id='38'"; error_log('yy'.$query3) ; 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']); } } } ?>