is there a was to write multi-dimensionl-arrays dynamicly?

[mediaholic]

is ther a way to write some thing like this dynamicly?

$menu[]=array(1, 0, 'produkte', array(3, 1, 'software', array(7, 3, 'grafik'), array(8, 3, 'audio')), array(4, 1, 'hardware')); 
$menu[]=array(2, 0, 'service', array(5, 2, 'konzeption'));
$menu[]=array(9, 0, 'kontakt');

a wont to create an multy-dim-array from mysql-record-set. so i can send it to flash via amf. i got the logik and sql funct.

i just don't know the way how to write multy-dim-arrays DYNAMICLY in php.
can anybody giv a brif description with some basic example?
or point me to some refeerenz

[leatherback]

Have you tried something along the lines of (Untested):

$result = mysql_query('select * from database where MyColum=$whateverIWant')

$i=0;

while($row=mysql_fetch_array)
  {
  $MyArray[$i] = array($row[1], $row[2], $row[3]);
  $i++;
  }

[mediaholic]

tnx,
but ure array is allways only two-dimensional, not multi-dimensional,(i mean [n].dimensional)
and my sql is much more complicated:

$sql="SELECT m1.id, m1.p_id, m1.name, count(*) as c, m2.name as no_childitem FROM ";
	$sql.="menu as m1 LEFT JOIN menu as m2 ON ";
	$sql.="m1.id=m2.p_id WHERE ";
	$sql.="m1.p_id=$node ";
	$sql.="GROUP BY m1.id ORDER BY m1.id, m1.p_id ASC";

by now, i make it like this

$menu=array();
function generate_array($arr, $lev){		//recrusiv machen
	global $menu;
	static $dim0, $dim1, $dim2, $dim3;

if($lev==0){
	$dim0=count($menu);
	$menu[$dim0]=$arr;	
}elseif($lev==1){
	$dim1=count($menu[$dim0-1]);//if new dim, only count; if appending, count -1		
	$menu[$dim0-1][$dim1]=$arr;
}elseif($lev==2){
	$dim2=count($menu[$dim1-1]);
	$menu[$dim0-1][$dim-1][$dim2]=$arr;
}elseif($lev==3){
	$dim3=count($menu[$dim2-1]);
	$menu[$dim0-1][$dim-1][$dim2-1][$dim3]=$arr;
}
}

but if i need fifth dimension i need new "if"
im trying tu make a recrusi fns of it?

any ideas?