Anonymous

function display_tree($root) {

	$sql = "SELECT lft, rgt 
			FROM navigation
            WHERE title= '$root'";
	$result = mysql_query($sql);
	$row = mysql_fetch_array($result);
	
	$right = array();
	
	$sql = "SELECT title, lft, rgt 
			FROM navigation
		    WHERE lft BETWEEN " . $row['lft'] . " AND " . $row['rgt'] . " 
			ORDER BY lft ASC";
	$result = mysql_query($sql);
	
	while ($row = mysql_fetch_array($result)) {
	   if ( count($right)>0 ){
		   while ( $right[count($right)-1] < $row['rgt'] ){
			   array_pop($right);
		   }
	   }
	   echo count($right).$row['title']."<br />\n";
	   $right[] = $row['rgt'];
   }
}