how to create queries like this...

[eluser]davidbehler[/eluser]
To solve your query problem:

Code:

$this->db->select('city.*, district.district_name');
$this->db->from('city');
$this->db->join('district', 'city.district_id = district.id');
$this->db->order_by('district.district_name', 'asc');
$this->db->order_by('city.city_name', 'asc');  

OR

$sql = "select city.*, district.district_name from city join district on city.district_id = district.id order by district.districr_name asc, city.city_name asc";

Does this work?