<?PHP
function listChilds($id, $depth=1) {
	$sql="SELECT * FROM navigation WHERE parentid = " . $id . " ORDER BY rank;";
	$qry=mysql_query($sql);	

	while($list = mysql_fetch_assoc($qry)) {
		$arrayChild=array( array(
			'depth'=>$depth,
			'id'=>$list['id'],
			'name'=>$list['name'],
			'parentid'=>$list['parentid'],
			'contentid'=>$list['contentid'],
			'rank'=>$list['rank'],
			'type'=>$list['type'] ));

		if(hasChild($list['id'])) {
			$depth=$depth+1;
			$arrayChild[count($arrayChild)]+=listChilds($list['id'], $depth);
			$depth=$depth-1;
		}
	}
	return $arrayChild;
}

function mainList() {
	$sql="SELECT * FROM navigation WHERE parentid = -1 ORDER BY rank;";
	$qry=mysql_query($sql);
	$depth=0;

	while($list = mysql_fetch_assoc($qry)) {
		$array=array( array(
			'depth'=>$depth,
			'id'=>$list['id'],
			'name'=>$list['name'],
			'parentid'=>$list['parentid'],
			'contentid'=>$list['contentid'],
			'rank'=>$list['rank'],
			'type'=>$list['type'] ));

		if(hasChild($list['id'])) {
			$array+=listChilds($list['id']);
		}
	}
	return $array;
}
?>