0) { $columns = mysql_num_fields($result); $fields = array(); for($i = 0; $i < $columns; $i++) { $field = mysql_field_name($result,$i); $response[$field] = $row[$i]; } $response["SQL_status"] = "success"; } else { $response["SQL_status"] = "update but select failed"; } } else { $response["SQL_status"] = "fail"; } $response_final["records"] = $return_arr; echo json_encode($response_final); ?> /* // update ¼º°ø½Ã if ($result_update) { // update confirmed. // select user_driver $query = "SELECT * FROM `users_driver` WHERE phone_no = '$phone_no'"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_row($result); $row_count = mysql_affected_rows(); if ($row_count>0) { $columns = mysql_num_fields($result); $fields = array(); for($i = 0; $i < $columns; $i++) { $field = mysql_field_name($result,$i); $response[$field] = $row[$i]; } $response["SQL_Result"] = "users_driver select success"; } else { $response["SQL_Result"] = "update but users_driver select failed"; } array_push($return_arr,$response); $driver_serial_no = $response["serial_no"]; unset($query,$result,$row,$row_count,$response,$columns,$fields); // select users_driver_alarm_setting $query = "SELECT * FROM `users_driver_alarm_setting` WHERE driver_serial_no = '$driver_serial_no'"; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_row($result); $row_count = mysql_affected_rows(); if ($row_count>0) { $columns = mysql_num_fields($result); $fields = array(); for($i = 0; $i < $columns; $i++) { $field = mysql_field_name($result,$i); $response[$field] = $row[$i]; } $response["SQL_Result"] = "users_driver_alarm_setting select success"; } else { $response["SQL_Result"] = "update but users_driver_alarm_setting select failed"; } array_push($return_arr,$response); } else { $response["SQL_Result"] = "update fail"; } */