= '" . $default_start_date . "' and date(appointment_date) <= '" . $default_end_date . "' and injury_classes_new ='" . $total_injury_class[$i] . "' or injury_classes_new like '%," . $total_injury_class[$i] . "' or injury_classes_new like '" . $total_injury_class[$i] . ",%' or injury_classes_new like '%," . $total_injury_class[$i] . ",%' "; error_log(" injury query " . $query); if (!$result = @mysqli_query($conn, $query)) { error_log("error in injury chart" . mysqli_error($conn)); exit(); } if (mysqli_num_rows($result) > 0) { while ($row = @mysqli_fetch_array($result)) { array_push($injury_data, $row[0]); // array_push($date_data, $row[1]); } } else { array_push($injury_data, 0); } } error_log("injury classification data trend " . print_r($injury_data, true)); ?>