$fly = "(" . $family_ids . ")"; $sql = "select model_id from {$model_factors_1} where family in {$fly}"; $model_arr = $db_object->get_single_column($sql); if (count($model_arr) > 0) { $model_ids = @implode(",", $model_arr); $models = "(" . $model_ids . ")"; $sql = "select avg(percent_fit) as percent from {$model_percent_fit} where model_id in {$models} \n\t\t\t\t\t\n\t\t\t\t\tand user_id='{$user}'"; $percent_arr = $db_object->get_a_line($sql); $total_percent += $percent_arr[0]; $count++; } } } if ($count >= 1) { $percent = $total_percent / $count; } else { $percent = 0; } $total = 100; $heads = array(array("Same Level Fit", 3, "c")); $array = array($percent, $total); $vals = $image->return_Array($array); $image->init(150, 150, $vals); $image->draw_heading($heads); $image->set_legend_percent(); $image->display($filename); } } $obj = new fit(); $obj->avg_percent_fit_iskill($db_object, $common, $image, $user_id);