Sitemap tree output recursion

[Nil0]

Hi super programmer brains.

I have som trouble with a script of mine. For now I use iteration within iteration within iteration and so on to output my sitemap. But that results in a hardcoded static level of depth in my site.
I created a table for each level and when a number in a level 2 page matches a level 1 ID, the link to the level 2 page will be shown on that level 1 page, and so on.
The thing is that I need it to be dynamic so one could add more levels of depth without changing the code, and I tryed to make recursion in 4 days now without luck.
Could anyone help me with turning this script into a dynamic recursion one?

This is the code I use for now:

<?php
for ($i1=0; $i1 < $num[1]; $i1++)
{
	$Lvl1PageID=mysql_result($result[1],$i1,"Lvl1PageID");
	$Lvl1Pagename=mysql_result($result[1],$i1,"Lvl1Pagename".$lang."");
	if ($Lvl1PageID>"0")
	{
		echo '<tr><td width="30"><td colspan="4"><br><br><a href="edit.php?ID=',$Lvl1PageID,'&lvl=1" target="_self" Title="',$Lvl1Pagename,'"><li>',$Lvl1Pagename,'</li></a><br><br></td></tr>';
	}
	for ($i2=0; $i2 < $num[2]; $i2++)
	{
		$Lvl2Pagename=mysql_result($result[2],$i2,"Lvl2Pagename".$lang."");
		$Lvl1PageID2=mysql_result($result[2],$i2,"Lvl1PageID");
		if ($Lvl1PageID==$Lvl1PageID2)
		{
			$Lvl2PageID=mysql_result($result[2],$i2,"Lvl2PageID");
			echo '<tr><td width="30"><td width="30"><td colspan="3"><a href="edit.php?ID=',$Lvl2PageID,'&lvl=2" target="_self" Title="',$Lvl2Pagename,'"><li>',$Lvl2Pagename,'</li></a><br><br></td></tr>';
		}
		for ($i3=0; $i3 < $num[3]; $i3++)
		{
			$Lvl3Pagename=mysql_result($result[3],$i3,"Lvl3Pagename".$lang."");
			$Lvl2PageID2=mysql_result($result[3],$i3,"Lvl2PageID");
			if ($Lvl2PageID==$Lvl2PageID2 && $Lvl1PageID==$Lvl1PageID2)
			{
				$Lvl3PageID=mysql_result($result[3],$i3,"Lvl3PageID");
				echo '<tr><td width="30"><td width="30"><td width="30"><td colspan="2"><a href="edit.php?ID=',$Lvl3PageID,'&lvl=3" target="_self" Title="',$Lvl3Pagename,'"><li>',$Lvl3Pagename,'</li></a><br><br></td></tr>';
			}
			for ($i4=0; $i4 < $num[4]; $i4++)
			{
				$Lvl4Pagename=mysql_result($result[4],$i4,"Lvl4Pagename".$lang."");
				$Lvl3PageID2=mysql_result($result[4],$i4,"Lvl3PageID");
				if ($Lvl3PageID==$Lvl3PageID2 && $Lvl2PageID==$Lvl2PageID2 && $Lvl1PageID==$Lvl1PageID2)
				{
					$Lvl4PageID=mysql_result($result[4],$i4,"Lvl4PageID");
					echo '<tr><td width="30"><td width="30"><td width="30"><td width="30"><td width="30"><td><a href="edit.php?ID=',$Lvl4PageID,'&lvl=4" target="_self" Title="',$Lvl4Pagename,'"><li>',$Lvl4Pagename,'</li></a><br><br></td></tr>';
				}
			};
		};
	};
};
?>

[bogu]

A verry interesting article about Storing Hierarchical Data in a Database.

[Nil0]

Thanks!

But I actually read a lot of articles already, including that one.
I managed so far to create the recursive function Starting to use one instance of the iterations I use already. But I've run into the problem that in the code that works the iterations are somewhat different. I don't know how to make use of the same iteration for all levels.

[bogu]

If u read it and u still don't know how to do it, then I'm sorry but that's all I can help u with, my suggestion about your code: "Deleted and start from scratch"...

[Nil0]

Thank you anyway.

Still looking for an idea to the soulution...
Will write if I get it elsewhere.