  |
132 | 132 | | $check = tep_db_fetch_array($check_query); |
| |
133 | 133 | | $entry_state_has_zones = ($check['total'] > 0); |
| |
134 | 134 | | if ($entry_state_has_zones == true) { |
 |
135 | | - | $zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name like '" . tep_db_input($state) . "%' or zone_code like '%" . tep_db_input($state) . "%')"); |
| |
| 135 | + | $zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name = '" . tep_db_input($state) . "' or zone_code = '" . tep_db_input($state) . "')"); |
|
136 | 136 | | if (tep_db_num_rows($zone_query) == 1) { |
| |
137 | 137 | | $zone = tep_db_fetch_array($zone_query); |
| |
138 | 138 | | $zone_id = $zone['zone_id']; |