also, das ganze soll ein baummeneu werden!!!!!
Code
Array
(
[0] => Array
(
[categoryID] => 1
[parent] =>
[name] => Root
[level] => 0
)
[1] => Array
(
[categoryID] => 80
[parent] => 1
[name] => ONLINE-TOUREN
[level] => 1
)
[2] => Array
(
[categoryID] => 86
[parent] => 80
[name] => bike-touren
[level] => 2
)
[3] => Array
(
[categoryID] => 95
[parent] => 86
[name] => oberalpen
[level] => 3
)
[4] => Array
(
[categoryID] => 102
[parent] => 95
[name] => dorf1
[level] => 4
)
[5] => Array
(
[categoryID] => 103
[parent] => 95
[name] => dorf2
[level] => 4
)
[6] => Array
(
[categoryID] => 104
[parent] => 95
[name] => dorf3
[level] => 4
)
[7] => Array
(
[categoryID] => 105
[parent] => 95
[name] => dorf4
[level] => 4
)
[8] => Array
(
[categoryID] => 96
[parent] => 86
[name] => unteralpen
[level] => 3
)
[9] => Array
(
[categoryID] => 101
[parent] => 86
[name] => regioXYZ
[level] => 3
)
[10] => Array
(
[categoryID] => 87
[parent] => 80
[name] => rennrad-touren
[level] => 2
)
[11] => Array
(
[categoryID] => 88
[parent] => 80
[name] => transalp-touren
[level] => 2
)
[12] => Array
(
[categoryID] => 81
[parent] => 1
[name] => EIGENPRODUKTE
[level] => 1
)
[13] => Array
(
[categoryID] => 82
[parent] => 1
[name] => FREMDPRODUKTE
[level] => 1
)
)
Alles anzeigen
also so muß die array ausehen, aber wenn ich diese aus der datenbank hole, sieht sie so aus:
Code
Array
(
[0] => Array
(
[categoryID] => 1
[parent] =>
[name] => Root
[level] => 0
)
[1] => Array
(
[categoryID] => 80
[parent] => 1
[name] => ONLINE-TOUREN
[level] => 1
)
[2] => Array
(
[categoryID] => 81
[parent] => 1
[name] => EIGENPRODUKTE
[level] => 1
)
[3] => Array
(
[categoryID] => 82
[parent] => 1
[name] => FREMDPRODUKTE
[level] => 1
)
[4] => Array
(
[categoryID] => 86
[parent] => 80
[name] => bike-touren
[level] => 2
)
[5] => Array
(
[categoryID] => 87
[parent] => 80
[name] => rennrad-touren
[level] => 2
)
[6] => Array
(
[categoryID] => 88
[parent] => 80
[name] => transalp-touren
[level] => 2
)
[7] => Array
(
[categoryID] => 95
[parent] => 86
[name] => oberalpen
[level] => 3
)
[8] => Array
(
[categoryID] => 96
[parent] => 86
[name] => unteralpen
[level] => 3
)
[9] => Array
(
[categoryID] => 101
[parent] => 86
[name] => regioXYZ
[level] => 3
)
[10] => Array
(
[categoryID] => 102
[parent] => 95
[name] => dorf1
[level] => 4
)
[11] => Array
(
[categoryID] => 103
[parent] => 95
[name] => dorf2
[level] => 4
)
[12] => Array
(
[categoryID] => 104
[parent] => 95
[name] => dorf3
[level] => 4
)
[13] => Array
(
[categoryID] => 105
[parent] => 95
[name] => dorf4
[level] => 4
)
)
Alles anzeigen
also fein säuberlich nach categoryIS sortiert.
da der code zum DB auslesen wie folg aussiht:
Code
$q = db_query("SELECT categoryID, name, parent FROM ".CATEGORIES_TABLE. " ORDER BY sort_order, name") or die (db_error());
while ($row = db_fetch_row($q))
{
$val[categoryID] = $row[categoryID];
$val[parent] = $row[parent];
$val[name] = $row[name];
$val[level] = count( catCalculatePathToCategory( $row[categoryID] ) )-1;
$res[] = $val;
}
Alles anzeigen
das problem ist jetzt, so brauche:
categorie1
parent 1 ( alle produkte mit categorie1 als parent )
uparent 1 ( alle produkte mit parent1 als parent )
uparent 2
parent2
parent3
categorie2
categorie3
categorie4
usw....
ich hoffe es ist verständlich??!??
gibt es dafür irgent eien möglichkeit ??