All pastes #963695 Raw Edit

Miscellany

public php v1 · immutable
#963695 ·published 2008-03-30 19:18 UTC
rendered paste body
some data from table categories:(category_id, name, left_node, right_node)1	 struktura 	1 529 	radius nautica 	4 1711 	skola jedrenja 	7 1421 	asda 		8 1122 	daaada 		9 10----php: $iterator = new RecursiveIteratorIterator(new recursiveArrayIterator($hierachy->SinglePath($node)));try {    foreach($iterator as $key=>$value)        {        echo $key.' -- '.$value.'<br />';        }    }catch(Exception $e)    {    echo $e->getMessage();    }------returns: name -- strukturaname -- skola jedrenjaname -- daaadaname -- radius nauticaname -- asdawhich is wrong order, why?It looks to me that query in method SinglePath() is wrong but i am not sure, here is the query:SELECT parent.name FROM categories AS node, categories AS parent WHERE node.left_node BETWEEN parent.left_node AND parent.right_node AND node.name = '{$node_name}' ORDER BY node.left_node