how to create queries like this...

[eluser]davidbehler[/eluser]
Sure, you can order by as many fields as you want.
What it does is this:
It orders the result alphabetically by the first field (in this case district_name). As there are multiple rows with the same district_name they can't be ordered properly and some default order would be in place for them (propably by primary key). Anyway, those with the same district_name will be ordered again, this time by city_name.

Take this example:

Code:

Un-ordered:
district_name | city_name
--------------------------
country 1 | test city
country 2 | other city
country 1 | more city
country 1 | city2000
country 2 | big_city
country 3 | small_city
country 2 | medium_city

order by district name asc, city_name asc:
district_name | city_name
--------------------------
country 1 | city2000
country 1 | more city
country 1 | test city
country 2 | big_city
country 2 | medium_city
country 2 | other city
country 3 | small_city