loop through navigation help please

[rswebdesign]

hello.

sorry but i can't work it out.

i gives me a list of headers but only the top header gives me any sub levels and its not giving me sub sub levels ... i just does not work. 🙁

this is the db structure

id',linkTitle',
listLevel',parent_id',

Header (id=1 - pnt=0 - level=header)

subTitle1 (id=2 - pnt=1 - level=title)
link1 (id=3 - pnt=1 - level=link)
link1 (id=4 - pnt=1 - level=link)
link1 (id=5 - pnt=1 - level=link)

subTitle2 (id=6 - pnt=2 - level=title)
link2 (id=7 - pnt=2 - level=link)
link2 (id=8 - pnt=2 - level=link)
link2 (id=9 - pnt=2 - level=link)

subTitle3 (id=10 - pnt=6 - level=title)
link3 (id=11 - pnt=6 - level=link)
link3 (id=12 - pnt=6 - level=link)
link3 (id=13 - pnt=6 - level=link)

subTitle4 (id=14 - pnt=10 - level=title)
link4 (id=15 - pnt=10 - level=link)
link4 (id=16 - pnt=10 - level=link)
link4 (id=17 - pnt=10 - level=link)

so it should look like this

level 1 = Header
level 2 = subTitle1 - link1 - link1 - link1
level 3 = subTitle2 - link1 - link1 - link1
level 4 = subTitle3 - link1 - link1 - link1
and so on....

this is my code.

<?PHP
echo'<div class="arrowlistmenu">';

$navHead = PhLists::find_all();
foreach($navHead as $navHeads){
$headID = $navHeads->id;		
$headLevel = $navHeads->listLevel;


//IF LEVEL IS HEADER
if($headLevel == "header"){

echo'<li><a><h3 class="menuheader expandable">'.$navHeads->linkTitle.'</h3></a></li>';

}else{	

echo'
<ul class="categoryitems">';

$navLink = PhLists::find_by_child($headID);
foreach($navLink as $navLinks){
$id = $navLinks->id;	
$PNT = $navLinks->parent_id;
$Level = $navLinks->listLevel;

//IF LEVEL IS LIST		
	echo $Level == "list" ? '<li><a>'.$navLinks->linkTitle.'</a></li>' : 

	$subLink = PhLists::find_by_child($id);
	foreach($subLink as $subLinks){
	$subid = $subLinks->id;	
	$subPNT = $subLinks->parent_id;
	$subLevel = $subLinks->listLevel;

// IF LEVEL IS TITLE	
		echo '<li><a href="#" class="subexpandable">'.$subLinks->linkTitle.'</a>
				<ul class="subcategoryitems" style="margin-left: 15px">
				<li><a>'.$subLinks->linkTitle.'</a></li>
				</ul>
		</li>';

	}
}

echo'</ul>';
}
}
echo'</div>';

?>

the function find_by_child($id); looks like this

public static function find_by_child($child){
		$sql = "SELECT * FROM ".self::$table_name." WHERE parent_id=".$child."";
		$result_array = self::find_by_sql($sql);
		return $result_array;
	}	

any help would be great.

thanks