php二维数组赋值问题

[lovephper]

我有个数据库查询操作查询出5个结果。
$sql="select name，picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);

$mypic_array = new array();

while($row=mysql_fetch_array($result)){

//对数组赋值
}
?>
我的问题是怎么把查询的结果赋值给这个数组赋值呢？另外我怎么全部读取出赋值后的结果呢
急急急

[genshing]

$sql="select name，picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);

$mypic_array = new array();

while($row=mysql_fetch_array($result)){
    $mypic_array = $row;
//对数组赋值 
  } 

[genshing]

$sql="select name，picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);

$mypic_array = new array();

while($row=mysql_fetch_array($result)){
    $mypic_array[] = $row;
//对数组赋值 
  } 

上面那个少打了

[wcqqq]

while($row = mysql_fetch_array($result , MYSQL_ASSOC)){ 

	$mypic_array[] = $row;

} 

[SamuelMe]

function array_tree($array){
	static $num=0,$new_array=array();
	if(is_array($array)){
		foreach($array as $key => $values){
			$array[$key] = array_tree($values);
		}
	} else{
		$new_array[$num] = $array;
		$num++;
		}
	return $new_array;
}
array_tree($mypic_array);

自己写的一个函数，主要功能是把一个N维数组转换成一个一维数组，然后你在遍历这个一维数组就可以的！

[战斗生活]

学习中

[parhelia_2001]

$mypic_array[] = $row;