How to store data in multidimensional array in a loop

[luftikus143]

Hi there,

I need to store three pieces of data - a result of a SQL query - in a multidimensional array, but don't really succeed. Sometimes it works, but then the output doesn't work accordingly.

My SQL result comes with something like this:

Africa   |    y2000   |   9430
Africa   |    y2005   |   9678
Europe   |    y2000   |   2314

where there are 6 regions and multiple years.

Last thing I came up with was this for stocking the data in the array:
[PHP]$sum_pop_total_dataset[] = array($row['reg_name'] => array($row['year'], $row['popt']));[/PHP]

That seemed to work. But then the output function went a bit wrong:
[PHP]while (list($key1) = each ($sum_pop_total_dataset))
{
echo "<br />key1: ".$key1;
while (list($key2, $value) = each ($sum_pop_total_dataset[$key1]))
{
echo "<br />key2: ".$key2." value: ".$value[0];

}
}[/PHP]

[HTML]key1: 0
key2: North America value: y_2005
key1: 1
key2: Europe value: y_2005
key1: 2
key2: Asia + Pacific value: y_2005[/HTML]

So, it seemed that the allocation of the SQL result to the principal variable didn't work correctly. But if I take the [] away from $sum_pop_total_dataset[]*= ..., than the variable is being re-initialized at each time.

Can someone give me a hint what I should do?

Thanks a lot!

[code green]

Don't quite follow what you are trying to achieve. Is it something like this?

Array([Africa]=>Array([y2000]=>9430,[y2005]=>9678),[Europe]=>Array([y2000]=>2314,[y2005]=>9000))

Which is an associtive array of 2d associative arrays. A multi-dimensional array if you like.
The terminology is personal preference on how you percieve the structure of an array.
Don't think you can do this in one line without any checking of the values in the current row.
But if you use ORDER BY in your SELECT statemenr it will help you greatly

ORDER BY country,year

[luftikus143]

Don't quite follow what you are trying to achieve. Is it something like this?

Array([Africa]=>Array([y2000]=>9430,[y2005]=>9678),[Europe]=>Array([y2000]=>2314,[y2005]=>9000))

Yepp, this is what I would like to have. But I would like to see that array beeing filled up in a loop.

P.S: The ordering isn't really important.

[code green]

The ordering isn't really important.

If you ORDER BY country,year then then the loop is something like

[PHP]$sum_pop_total_dataset = array();
$year_pop = array();
$country = $records[0]['reg_name'];
foreach($records as $row)
{
if(!strcmp($country,$row]['reg_name']) #are we still with the same country
$year_pop[$row['year']] = $row['popt'];
else
{
$sum_pop_total_dataset[$country]=$year_pop; #insert the sub array into main array
$country = $row['reg_name']; #assign the next country
$year_pop[$row['year']] = $row['popt']; #continue
}
}
print_r($sum_pop_total_dataset); #Lets have a look;[/PHP]
Without ORDER BY more if statements are needed