Display children of selected parent in hierchecal menu

[[deleted]]

I'm designing a hierachical menu that is dynamic using MySQL and PHP. What I am trying to achieve is for the menu to display the child menu for the selected parent as well as the non-selected parents.

For example:

PARENT 1
CHILD 1
CHILD 2

PARENT 2

PARENT 3

What I am doing now is echoing the parent from the URL and then selecting the children from that value. I then echo the parents that are not the value in the URL. This works, but each time I click on a parent that value is displayed at the top of all of the other parents.

Does anyone have any suggestions on how to implement this in a better way?

Thanks.

[Hiccup]

I'm not clear on what you're trying to do but I think reading up on arrays will help you greatly. It's all in the manual.

[[deleted]]

Let me try to clarify. I have three parent elements User Manager, Reports, Content. Each parent has at least one child.

If the parent element User Manager has been clicked on I want to show all of the associated children elements directly below User Manager yet still show the other parent elements Reports and Content without their associated children.

I have begun to look at the arrays section in the manual, but would still appreciate some assistance.

Thanks.

[mooseday]

Check http://www.web-max.ca/ccit/ - i think this is what you mean. Its easiest to do it in Java - load all the parent and children items in from PHP and let java do the show/hide. Create <DIV ID="CHILD{num}" onclick="checkexpand(this)">'s for each child item, put the parent item in a <SPAN ID={num}>.

ie

<script LANGUAGE="JavaScript">
<!--

NS6=false;
IE4=(document.all);
if (!IE4) {NS6=(document.getElementById);}
NS4=(document.layers);
function checkExpand(sElem)
{
//var sElem = event.srcElement;

if ("" != sElem.id) 
{
	var ch = sElem.id + "CHILD";

	if(NS6)
	{
		el = document.getElementById(ch);
	}
	else
	{
	 	el = document.all[ch];
	}

	if (null!=el) el.style.display = "none" == el.style.display ? "" : "none"
	event.returnValue=false;
}

}

// --></script>

<span id="1" onclick="checkExpand(this)">PARENT ITEM 1</SPAN>
<div id="CHILD1" style="display:none;">
Child 1
Child 2
</div>
<span id="2" onclick="checkExpand(this)">PARENT ITEM 2</SPAN>
<div id="CHILD2" style="display:none;">
Child 3
Child 4
</div>

[[deleted]]

In case anyone is interested this is how I resolved the problem.
<?php
$qGetNodes = "select menuid,menuname,url,parent,displayname from tblmenu where parent = 0 order by displayname asc";
$rGetNodes = mysql_query($qGetNodes) or die("Error in query: $qGetNodes. " . mysql_error());
$counter = 0;

	while($node = mysql_fetch_array($rGetNodes))
		{	
?>
	<tr>
		<td valign="top" class="root_td">
			<a id="a_root_<?php echo $counter; ?>"  border="0"  style="cursor:hand; text-align:top;">
			&nbsp;<a class="root_td" href="<?php echo $node[2];?>"><?php echo $node[1]; ?></a>
		</td>
	</tr>
	<tr>
		<td valign="top" id="td_root_<?php echo $counter++; ?>" class="child_td">
			<table width="100%">
				<?php

					$qGetChildren = "select menuid,menuname,url,parent,displayname from tblmenu where parent = {$node[0]} order by displayname asc";
					@$childResult = mysql_query($qGetChildren) or die("Error in query: $qGetChildren. " . mysql_error());;

					while($child = mysql_fetch_row($childResult))
						{
					?>
				<tr>

					<td class="child_td">
						<a style="padding-left: 10px;" class="child_td" href="<?php echo $child[2]; ?>"><?php echo $child[1]; ?></a>
					</td>

				</tr>

				<?php
					}
				?>

			</table>
		</td>
	</tr>

<?php
	}
?>