Menu

[Pro_Luv]

Hi,

I been trying to figure out how to do this but I have no luck in finding out how to...

I have a vertical list menu... I want to load the main menu titles from the database and I want to load the sub menu from the database..

<ul>
<li><a href="#">main menu</a>
<ul>Sub menu</ul>
</li>

<li><a href="#">main menu 1</a>
<ul>Sub menu</ul>
</li>

<li><a href="#">main menu 2</a>
<ul>Sub menu</ul>
</li>

<li><a href="#">main menu 3</a>
<ul>Sub menu</ul>
</li>
</ul>

I tried this it works but it doesn't group them it prints

the main category then the sub menu... it prints out the main

category again and again and the sub menu.. like if there's 2

sub menu's that's meant to be under a certain main category

say for example. Home is the main category it does this:

Home
Tables

Home
Lounge Suites

It does each sub menu seperately...

<?

$conn = pg_connect ("host= localhost port=5432 dbname=test");

#==============================================================

$sql  = "SELECT DISTINCT tblproductcategory.productcategoryid,tblproductcategory.productcategory, tblproducttype.productcategoryid,tblproducttype.producttype FROM tblproductcategory";
	$sql .= " INNER JOIN tblproducttype ON tblproducttype.productcategoryid = tblproductcategory.productcategoryid";
	$sql .= " GROUP BY tblproductcategory.productcategoryid,tblproductcategory.productcategory, tblproducttype.productcategoryid,tblproducttype.producttype";
	$sql .= " ORDER BY tblproductcategory.productcategoryid,tblproductcategory.productcategory, tblproducttype.productcategoryid,tblproducttype.producttype";

$r_query = pg_query($conn, $sql);

 while($arr=pg_fetch_array($r_query))
		{

	 If($arr[1] <> $arr[1]){
		Print "<b>".$arr[1]."</b><br>";
	 }
		Print $arr[3]."<br>";
   }
?>

[Kudose]

I think you need recursion.

i.e.

Get top level menu items
While display top level menu item !== FALSE
  Get sub items
  While display sub level menu item !== FALSE
    Show sub level menu item
End

[rikmoncur]

there ya go

http://www.codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/

[Pro_Luv]

Hi

Can someone tell me why this code only retrieves 1 submenu for each main menu ? Eg,
Home
Beds
Electronics
LCD Screens
Small Appliances
Kettles
Large Appliances
Washing Machines

$sql= "SELECT productcategory FROM tblproductcategory";
$r_query = pg_query($conn, $sql);

while($r=pg_fetch_row($r_query))
	{
		$categories[]=$r[0];
		//print $r[0]."<br>";
}

$sql  = "SELECT tblproductcategory.productcategoryid, tblproductcategory.productcategory, tblproducttype.productcategoryid, tblproducttype.producttype FROM tblproductcategory";
$sql .= " INNER JOIN tblproducttype ON tblproducttype.productcategoryid = tblproductcategory.productcategoryid";
$sql .= " WHERE tblproductcategory.active=true";
$sql .= " GROUP BY tblproductcategory.productcategoryid, tblproductcategory.productcategory, tblproducttype.productcategoryid, tblproducttype.producttype";
$sql .= " ORDER BY tblproductcategory.productcategoryid, tblproductcategory.productcategory, tblproducttype.productcategoryid, tblproducttype.producttype DESC";
$r_query = pg_query($conn, $sql);

$i=0;
	while($r = pg_fetch_array($r_query))
	{		
		if($r[1]==$categories[$i])
		{
			if($i!=0)
			{
				echo "</ul>";
			}
			echo "<ul>{$categories[$i++]}";
			echo "<li>{$r['producttype']}</li>";
		}
		else
		{
			echo "<li>{$r['producttype']}</li>";
			//echo "<ul>{$categories[$i++]}";

	}
}

I have more than 1 submenu for each main menu but it only gets the 1st 1 please help 😕