[eboiteanu]

Hi,

I want display a tree menu structure like that:

- category1
- subcategory11
-subcategory 111
-subcategory 112
-subcategory 113
+ subcategory 12
+subcategory 13
+category2
....
(like menu of http://msdn.microsoft.com/library/de...commandids.asp, left side)


My dates resides in mysql table folders with fileds:
id //auto_increment
parent_id //id of category
name //name of category


I'm create following script:

<?
include_once"config/config.php"; // my config to connect mysql
$sql1 = "SELECT * FROM folders WHERE parent_id = '0'";
$result1 = mysql_query($sql1) or die(mysql_error());
while ($na1 = mysql_fetch_array($result1))
{
$category = $na1['id'];
$categorydesc = $na1['name'];
echo"<a href='http://magda/index.php?id=$category'>$categorydesc</a><br>";
if($id == $category)
{
$sql2 = "SELECT * FROM folders WHERE parent_id = '".$category."'";
$result2 = mysql_query($sql2) or die(mysql_error());
while ($na2 = mysql_fetch_array($result2))
{
$subcategory = $na2['id'];
$subcategorydesc = $na2['name'];
echo"<a href='http://magda/index.php?id=$subcategory'>$subcategorydesc</a><br>";
}
}
}
?>

That script display me a tree structure but just to level2 ...

Please help me with some sugestions,
Eugen

[eboiteanu]

I try with another way but not display the tree structure very well ...

function build_category_tree_sitemap1(&$output, $parent, $indent="") {




$qid = db_query("SELECT id, name FROM folders WHERE parent_id = $parent");

while ($cat = db_fetch_object($qid)) {


$output .=$indent."<br><a href=http://magda/backoffice/items/addkoppeling.php?id1=".$cat->id.">".$cat->name."</a>".$cat->id."<br>";
if ($cat->id !== $parent) {
build_category_tree_sitemap1($output, $cat->id, $indent."<br>&nbsp;&nbsp;");
}
}

}

$qid0 = db_query("SELECT id, name FROM folders WHERE parent_id = 0");
while(list($id,$name)=mysql_fetch_row($qid0)){
echo"<a href=http://magda/backoffice/items/addkoppeling.php?parent=$id>$name</a><br>";

build_category_tree_sitemap1($category_options,$id 1);



echo"$category_options";}
?>