MySQL table to PHP multidimensiona l array

[mouac01]

Let's say I have this MySQL table.

Year Region Amount
2007 West 100
2007 East 200
2007 North 300
2007 South 400
2008 West 500
2008 East 600
2008 North 700
2008 South 800

How would I get this table into a multidimensiona l array in PHP. I'm
looking for code that will generate the array below automatically from
a MySQL table/query. Thanks...

tbl[] =
array("2007" =array("West" =100, "East" =200, "North" =300,
"South" =400),
"2008" =array("West" =500, "East" =600, "North" =700,
"South" =800))

[Sjoerd]

mo*****@yahoo.c om wrote:

How would I get this table into a multidimensiona l array in PHP.

Something like this:

$multiarray = array();
while ($result = mysql_fetch_ass oc())
{
$year = $result['year'];
$multiarray[$year] = $result;
}

[mouac01]

Thanks, Sjoerd. I'll give it shot. Looks like it should work
though. However, shouldn't it be like this?

$multiarray = array();
while ($result = mysql_fetch_ass oc())
{
$year = $result['year'];
$region = $result['region'];
$amount= $result['amount'];
$multiarray[$year][$region][] = $amount;
}