I have a database that was created dynamically just for trial purposes. I created a parent(home), set its children and then created children of those children(sub children you can say).
Now i want to only get the list of all the Sub-Children.
My Code
$pages = $this->getDoctrine()->getRepository('BloggerBlogBundle:Page');
$nodes = $pages->getChildren();
$parent = $nodes[0]; //get Parent node
$rootNodes = $parent->getChildren(); // get Children of Parent Nodes
foreach($rootNodes as $node)
{
$nodes = $node->getChildren(); // get Children of Children
}
Now i am returning $nodes to my view and in return i only get sub-children of only one children node instead of all the sub-children of all the children.
What mistake i am making here? Please help, Thanks !!!