[Deprecated] DMZ 1.6.2 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@BaRzO

I thought of a trick to get it down to 2 queries! Combine both techniques:

Code:

$regions = new Region();
$regions->order_by('name')->get();

$city = new City();

$city->include_related('region', array('id', 'name', ...));
$city->order_by_related('region', 'name', 'ASC'); // order by region first
$city->order_by('name', 'ASC'); // then by city name
$city->get();

$city_index = 0;
$total_cities = count($city->all);

foreach($regions as $r) {
    echo($c->region_name);
    while(($city_index < $total_cities) &&
            ($city->all[$city_index]->region_name == $r->name)) {
        $c = $city->all[$city_index];
        // output city info
        echo($c->name);
        $city_index++;
    }
}