  |
102 | 102 | | $check = tep_db_fetch_array($check_query); |
| |
103 | 103 | | $entry_state_has_zones = ($check['total'] > 0); |
| |
104 | 104 | | if ($entry_state_has_zones == true) { |
 |
105 | | - | $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) . "%')"); |
| |
| 105 | + | $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) . "')"); |
|
106 | 106 | | if (tep_db_num_rows($zone_query) == 1) { |
| |
107 | 107 | | $zone = tep_db_fetch_array($zone_query); |
| |
108 | 108 | | $zone_id = $zone['zone_id']; |