set_charset("utf8"); if (!$link) { echo "Error: Unable to connect to MySQL." . PHP_EOL; echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL; echo "Debugging error: " . mysqli_connect_error() . PHP_EOL; exit; } ?> query($codequery); while($row = $result->fetch_assoc()) { $id = $row['result_value']; } return $id; } function get_salary_lookup($data){ $codequery = "select result_value from xx_az_salary_lookup where lookup_value = '$data'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id = $row['result_value']; } return $id; } function get_branch_lookup($data,$data2){ $codequery = "select result_value,cash_result_value,mono_result_value from xx_az_branch_lookup where lookup_value = '$data'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id = $row['result_value']; $id2 = $row['cash_result_value']; $id3 = $row['mono_result_value']; } if($data2 == 'MonoBrand'){ return $id3; }else{ if($data2 == 'Cash'){ return $id2; }else{ return $id; } } } function get_bank_lookup($data){ $codequery = "select result_value from xx_az_bank_lookup where lookup_value = '$data'"; //echo $codequery; $result = $GLOBALS["link"]->query($codequery); while($row = $result->fetch_assoc()) { $id = $row['result_value']; } return $id; } ?>