Build Navigation Tree (!BEWARE! not simple)

[antoinep]

Aloha everybody,

I want to make a navigation frame, that builds trees (nodes and sons). It comes from a table and normally must be a recursive function. But I don´t know how to make it in PHP.
When i make it like this (see below) he ignores the first while loop.

It´s not so easy!BEWARE!!

But anyway thank you for your help.
See you ;-))

$getAll1=mssql_query("SELECT objid, this2parent, name, sort_order
FROM tNavigation
ORDER BY this2parent, sort_order");

$getAll2=$getAll1;

while ($row1=mssql_fetch_array($getAll1))
{
$objid1=$row1['objid'];
$this2parent1=$row1['this2parent'];
$name1=$row1['name'];
echo $objid1.$this2parent1.$name1."<BR>";
while ($row2=mssql_fetch_array($getAll2))
{
$objid2=$row2['objid'];
$this2parent2=$row2['this2parent'];
$name2=$row2['name'];
echo $objid2.$this2parent2.$name2."<BR>";
}
}

[Weedpacket]

Why not load all the rows into an array first, and then loop through that? (I'm not entirely convinced that resource handles can be copied like that - I've never been tempted to try.)

And maybe rework the array so that it more closely reflects the tree structure - say something like $tree[$node]['parent']=$tree[$parent]; - although it may be more useful to have a $tree[$node]['children'] array containing a node's children (with $tree[$node]['children']=false if it's a leaf).

Depending on the extact representation of the tree in your table, statements like the above could be used in a single pass to build the tree. if $foo is a parent of $bar, set $tree[$foo]['children'][]=$tree[$bar] and/or $tree[$bar]['parent']=$tree[$foo].