Hello
I have a problem regarding a tree structure im trying to create in PHP and
I have 2 questions i need help with.
1.
The thing is im almost finished with my tree structure and as usual i bump in to a problem, the thing is the tree structure lists out the right values but in the wrong way i wont it in.
The way i won’t it to look like is this
1 main category
2 type of category
3 type of product in the selected
1---2----3
|----|
|----|----|
|----|----|
|
|----|
|----|----|
The problem now is that i have problem listing the tree is right way, now everything just gets out in after each other and that makes it hard for me to build up a tree and i don’t know how i going to t solve it.
2.
I wonder if the array is dynamic or not?
What i mean is if i would remove or add something in 1, 2, 3 levels would everything crash or would one branch just stop working.
Why i asked this is just that im trying to program in a new way.
## Set array menu namese and menu id
$MenuArtID = array();
$MenuArtName = array();
## Set array menu sublevel 1 and sublevel 1 ids
$SubArtID1 = array();
$SubArtName1 = array();
## Set array menu sublevel 2 and sublevel 2 ids
$SubArtID2 = array();
$SubArtName2 = array();
$menu_result = mysql_query("SELECT ProductParentNumber,
ProductParentName
FROM productparentregister ORDER BY ProductParentName");
while($menu = mysql_fetch_array($menu_result)){
$MenuArtID[] = $menu['ProductParentNumber'];
$MenuArtName[] = $menu['ProductParentName'];
$sub1_result = mysql_query("SELECT ProductParentNumber,
ProductChildNumber,
ProductChildName
FROM productchildregister WHERE ProductParentNumber='$menu[ProductParentNumber]' ORDER BY ProductChildName");
while($sub1 = mysql_fetch_array($sub1_result)){
$SubArtID1[][$sub1['ProductParentNumber']] = $sub1['ProductChildNumber'];
$SubArtName1[][$sub1['ProductParentNumber']] = $sub1['ProductChildName'];
$sub2_result = mysql_query("SELECT ProductParentNumber,
ProductChildNumber,
ProductBabyNumber,
ProductBabyName
FROM productbabyregister WHERE ProductParentNumber='$sub1[ProductParentNumber]' AND ProductChildNumber='$sub1[ProductChildNumber]' ORDER BY ProductBabyName");
while($sub2 = mysql_fetch_array($sub2_result)){
$SubArtID2[][$sub2['ProductParentNumber']][$sub2['ProductChildNumber']] = $sub2['ProductBabyNumber'];
$SubArtName2[][$sub2['ProductParentNumber']][$sub2['ProductChildNumber']] = $sub2['ProductBabyName'];
}
}
}
foreach(array_keys($MenuArtID) as $MenuID) {
## menu main category
echo "<a href=product.php?CatArt=".$MenuArtID[$MenuID].">".$MenuArtName[$MenuID]."</a> >";
## sublevel 1 catogory
echo "<a href=product.php?CatArt=".$_GET['CatArt']."&CatArtType=".$SubArtID1[$MenuID][$_GET['CatArt']].">".$SubArtName1[$MenuID][$_GET['CatArt']]."</a> >>";
## sublevel 2 catogory / products
echo "<a href=product.php?CatArt=".$_GET['CatArt']."&CatArtType=".$SubArtID2[$MenuID][$_GET['CatArt']][$_GET['CatArtType']]."&CatArtID=".$SubArtID2[$MenuID][$_GET['CatArt']][$_GET['CatArtType']].">".$SubArtName2[$MenuID][$_GET['CatArt']][$_GET['CatArtType']]."</a> || ";
}
?>
