$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