$sql = "SELECT * FROM tbl_courier_rate WHERE `courier_name` = '{$courier}' AND `active_status` = '{$status}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
/*
# ----------------------------------------------------------------------
# DEFINED VARIABLE
# ----------------------------------------------------------------------
*/
$country = $_POST['country'];
$province = $_POST['province'];
/*
# ----------------------------------------------------------------------
# CALL FUNCTIONS
# ----------------------------------------------------------------------
*/
$count_city = count_city($country, $province);
$data_city = get_city($country, $province);
/*
# ----------------------------------------------------------------------
# CONTROL
# ----------------------------------------------------------------------
*/
if ($count_city['rows'] > 0) {
foreach ($data_city as $data_city) {
echo '<option value="' . $data_city['city_name'] . '">' . $data_city['city_name'] . '</option>';
}
} else {
echo '0';
}
| SORTING |
|--------------------|
*/
$equal_search = array('visibility');
$default_sort_by = "category_name";
$pgdata = page_init($equal_search, $default_sort_by);
// static/general.php
$page = $pgdata['page'];
$query_per_page = $pgdata['query_per_page'];
$sort_by = $pgdata['sort_by'];
$first_record = $pgdata['first_record'];
$search_parameter = $pgdata['search_parameter'];
$search_value = $pgdata['search_value'];
$search_query = $pgdata['search_query'];
$search = $pgdata['search'];
$full_order = count_city($search_query, $sort_by, $query_per_page);
$total_query = $full_order['total_query'];
$total_page = ceil($full_order['total_query'] / $query_per_page);
// CALL FUNCTION
$listing_order = get_city($search_query, $sort_by, $first_record, $query_per_page);
// HANDLING ARROW SORTING
if ($_REQUEST['srt'] == "category_name DESC") {
$arr_order_number = "<span class=\"sort-arrow-up\"></span>";
} else {
if ($_REQUEST['srt'] == "category_name") {
$arr_order_number = "<span class=\"sort-arrow-down\"></span>";
} else {
$arr_order_number = "<span class=\"sort-arrow-down\"></span>";
}
}
// STORED VALUE
