setQuery($catsload); $allcats = $database->loadObjectList(); $firstitem[] = mosHTML::makeOption( '0', $first); $allcats = array_merge($firstitem, $allcats); $catselect = mosHTML::selectList( $allcats, 'catid', $show.' size="1" class="inputbox" ', 'value', 'text', mosGetParam( $_GET, 'catid' ) ); */ $query = "SELECT t1.catid, t1.name, t2.parentid FROM #__sobi2_categories AS t1 LEFT JOIN #__sobi2_cats_relations AS t2 USING(catid) WHERE catid > 1 ORDER BY parentid, ordering"; $database->setQuery($query); $cats = Array(); foreach($database->loadObjectList() as $k => $v) { $parent = $v->parentid; $id = $v->catid; $name = $v->name; if($parent == 1) $cats[$id] = Array('name' => $name, 'sub' => Array()); else $cats[$parent]['sub'][$id] = Array('name' => $name); } $x = 1; foreach($cats as $k => $v) { $name = $v['name']; $sub = $v['sub']; if($x > 1) echo "\n"; echo "

"; echo "
• $name
"; foreach($sub as $k2 => $v2) { $name2 = $v2['name']; $link = "index.php?option=com_sobi2&Itemid=2&sobi2Task=mySearch&catid=$k2"; $link = sefRelToAbs($link); echo "
• $name2
"; } $x++; } echo "

"; ?>