return array in a function

[ikkk]

<?

function schuif($i,$c) {
include("datab.inc.php");

{ $Query = "SELECT Naam,Map_Id FROM map WHERE Parent_ID='$i'and Beheerder_Id='1'";
$Result = mysql_db_query ($DBName, $Query, $Link);
// Fetch the results from the database.
while ($row = mysql_fetch_array ($Result)){ $c++;$spatie="";
for($j=0;$j<$c;$j++)
{$spatie=$spatie.'&nbsp;';}
$optie= $spatie.$row['Naam']."<br>";
$opties[]=$optie;
schuif($row['Map_Id'],$c);

     $c--;

}
} return $opties;
}
include("datab.inc.php");
$Query = "SELECT Naam,Map_Id,Parent_Id FROM map WHERE Beheerder_ID='1'";
$Result = mysql_db_query ($DBName, $Query, $Link);
// Fetch the results from the database.
$i=0;
$Row = mysql_fetch_array ($Result);
$test[]= schuif($i,$i);
echo $test[2];
mysql_close ($Link);
?>
why can he not return the array???

[paulnaj]

It does help to format your code ... it's a lot easier to debug.

Having done that, the only thing I can see is that your 'recursive' call to the schuiff() function is not being stored in a variable.

<? 
function schuif($i, $c) { 
	include("datab.inc.php"); 
	{ 
		$Query = "SELECT Naam,Map_Id FROM map WHERE Parent_ID='$i' and Beheerder_Id='1'"; 
		$Result = mysql_db_query ($DBName, $Query, $Link); 
		// Fetch the results from the database. 
		while ($row = mysql_fetch_array ($Result)){ 
			$c++;
			$spatie=""; 
			for($j = 0; $j < $c; $j++){
				$spatie = $spatie.' ';
			}
			$optie = $spatie.$row['Naam']."<br>"; 
			$opties[] = $optie; 
			schuif($row['Map_Id'], $c); 
			$c--; 
		} 
	} 
	return $opties; 
}

include("datab.inc.php"); 
$Query = "SELECT Naam,Map_Id,Parent_Id FROM map WHERE Beheerder_ID='1'"; 
$Result = mysql_db_query ($DBName, $Query, $Link); 
// Fetch the results from the database. 
$i = 0; 
$Row = mysql_fetch_array ($Result); 
$test[]= schuif($i, $i); 
echo $test[2]; 
mysql_close ($Link); 
?>