How to make select tag in alphabetical order?

Question

SQL

There is code in the OpenCart engine:

<?php
// *	@copyright	OPENCART.PRO 2011 - 2017.
// *	@forum	http://forum.opencart.pro
// *	@source		See SOURCE.txt for source and other copyright.
// *	@license	GNU General Public License version 3; see LICENSE.txt

class ModelLocalisationZone extends Model {
  public function getZone($zone_id) {
    $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "zone WHERE zone_id = '" . (int)$zone_id . "' AND status = '1'  ORDER BY country_id");
      
    return $query->row;
  }

  public function getZonesByCountryId($country_id) {
    $zone_data = $this->cache->get('zone.' . (int)$country_id);

    if (!$zone_data) {
      $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "zone WHERE country_id = '" . (int)$country_id . "' AND status = '1' ORDER BY country_id");

      $zone_data = $query->rows;

      $this->cache->set('zone.' . (int)$country_id, $zone_data);
    }

    return $zone_data;
  }
}

For the country and regions. How to sort them alphabetically?
PS In php I am zero

Answer 1

instead of order by country_id write order by country_name, region_name (the name of the field in which the country, region is stored)