I cannot wrap my head around this...I have an array that looks like:
Array
(
[0] => Array
(
[0] => 20120412
[1] => United States
[2] => Illinois
[3] => Marion
[4] => 2
)
[1] => Array
(
[0] => 20120412
[1] => United States
[2] => Illinois
[3] => Carbondale
[4] => 2
)
[2] => Array
(
[0] => 20120412
[1] => United States
[2] => Illinois
[3] => Carbondale
[4] => 2
)
)
I am wanting it to be like:
array("United States" => array("Illinois" => array("Carbondale" => "4")));
So that it takes the Country out, Then the State, then adds together all of the city's numbers.
So far all I have is:
foreach($location_google_data3 as $location_google_data4){
if($location_google_data4[0]==date("Ymd")){
$today_visitsbycountry[$location_google_data4[1]]+=$location_google_data4[4];
}
}
This gives me an array with the country and number of visits so that I can iterate through it later, but not sure how to proceed with the rest.