  |
182 | 182 | | |
| |
183 | 183 | | return $Qzone->value('zone_code'); |
| |
184 | 184 | | } |
 |
| 185 | + | |
| |
| 186 | + | function getCountryZones($id) { |
| |
| 187 | + | global $osC_Database; |
| |
| 188 | + | |
| |
| 189 | + | $zones_array = array(); |
| |
| 190 | + | |
| |
| 191 | + | $Qzones = $osC_Database->query('select zone_id, zone_name from :table_zones where zone_country_id = :zone_country_id order by zone_name'); |
| |
| 192 | + | $Qzones->bindTable(':table_zones', TABLE_ZONES); |
| |
| 193 | + | $Qzones->bindInt(':zone_country_id', $id); |
| |
| 194 | + | $Qzones->execute(); |
| |
| 195 | + | |
| |
| 196 | + | while ($Qzones->next()) { |
| |
| 197 | + | $zones_array[] = array('id' => $Qzones->valueInt('zone_id'), |
| |
| 198 | + | 'name' => $Qzones->value('zone_name')); |
| |
| 199 | + | } |
| |
| 200 | + | |
| |
| 201 | + | return $zones_array; |
| |
| 202 | + | } |
|
185 | 203 | | } |
| |
186 | 204 | | ?> |