= '" . $default_start_date . "' and date(appointment_date) <= '" . $default_end_date . "' and (ailments_new='$ailment_id' or ailments_new like '%,$ailment_id%' or ailments_new like '%$ailment_id,%' or ailments_new like '%,$ailment_id,%') "; $result_query = mysqli_query($conn, $sql_query); $row_query = mysqli_fetch_assoc($result_query); $data[$ailment_id] = $row_query['count']; array_push($backColor, $colors[$i]); // error_log("in diagnosis chart" . $data . " " . ($row_query['count'])); // $v = $data; } arsort($data); $val = array(); $keys = array_keys($data); error_log("all keys ." . print_r($keys, true)); for ($i = 0; $i < 10; $i++) { // $val[$i] = $data[$keys[$i]]; array_push($val, $data[$keys[$i]]); $label[$i] = getFieldFromTable('ailment_name', 'ailment', 'ailment_id', $keys[$i]); } error_log("whole data " . print_r($data, true)); error_log("refined data " . print_r($val, true)); ?>