} } if ($action == "update_budget") { $query = "UPDATE `fp_hks_tbl` SET `budget`={$bud} WHERE id={$hk_id}"; $result = mysql_query($query); if (!$result) { echo mysql_error(); } else { echo $hk_id; } } //end hk supplies// # End financial perspetive # # Customer Perspective # if ($action == "view_quality") { $emp_querys = emp_querys($id, null); // echo $emp_querys; $emp_result = mysql_query($emp_querys); while ($emp_row = mysql_fetch_array($emp_result, MYSQL_ASSOC)) { $last = $emp_row['last']; $first = $emp_row['first']; $middle = $emp_row['middle']; $pos = $emp_row['position']; $name = $last . ", " . $first . " " . $middle; } $body = '<div class="box-content responsive" style="font-size: 12px;"> <center><h3>' . $name . '</h3> <h5>' . $pos . '</h5></center> </div>'; $body .= '<div class="box-content accordion" id="accordion" style="padding:0px;">'; for ($x = 1; $x <= 12; $x++) {
function getemp_complete($id) { $emp = array(); $query = emp_querys($id, null); // echo $query; $query = mysql_query($query); while ($row = mysql_fetch_assoc($query)) { $emp = $row; } return $emp; }