Online PHP editor | output for Uf30i

<?php $array = ( [0] => Array ( [cnt_name] => germany [ent_func] => sec [COUNT(*)] => 31 ) [1] => Array ( [cnt_name] => germany [ent_func] => Coach [COUNT(*)] => 1 ) [2] => Array ( [cnt_name] => germany [ent_func] => officer [COUNT(*)] => 2 ) [3] => Array ( [cnt_name] => france [ent_func] => manager [COUNT(*)] => 3 ) [4] => Array ( [cnt_name] => france [ent_func] => sec [COUNT(*)] => 10 ) ); $countries = array(); $totals = array(); foreach($array AS $subarray) { $countries[$subarray['cnt_name']][$subarray['ent_func']] = $subarray['COUNT(*)']; } print_r($countries);