Mam tablice i che wysietlic za pomoca SMARTY drzewko.
Kod szablonu ktory wysitela mi to drzewko jest taki:
<? {section name=i loop=$kat_firmy} {if $rekord == $kat_firmy[i][0]} {* selected node => point category and don't make a link *} <b> {$kat_firmy[i][1]}</b><br> {else} {* not selected node => make a link to a category *} <img src="nav_link_0.gif"><a href="4,0,{$kat_firmy[i][0]},0,0.html" {if $kat_firmy[i][2] > 0}{else}{/if}>{$kat_firmy[i][1]}</a><br> {/if} {/section} ?>
I teraz jednym zpaytniem do bazy robie tablice wszytkich kategorii. (wykorzytuje klase EZ_SQL
<?php $kat_firmy = $db->get_results("SELECT id,nazwa, parent FROM katalog_firmy_cat order by nazwa,parent", ARRAY_N); ?>
Dzieki temu zpaytaniu otrzymuje taka o to tablice:
Kod
Array (
[0] => Array ( [0] => 2 [1] => Banki [2] => 0 )
[1] => Array ( [0] => 1 [1] => Internet i Telekomunikacja [2] => 0 )
[2] => Array ( [0] => 5 [1] => Kultura i Sztuka [2] => 0 )
[3] => Array ( [0] => 4 [1] => Motoryzacja [2] => 0 )
[4] => Array ( [0] => 10 [1] => Mot_podkat [2] => 4 )
[5] => Array ( [0] => 7 [1] => Podkat [2] => 1 )
[6] => Array ( [0] => 8 [1] => podkat 2 [2] => 1 )
[7] => Array ( [0] => 9 [1] => podkat2_1 [2] => 8 )
[8] => Array ( [0] => 6 [1] => Rozrywka i Gastronomia [2] => 0 )
[9] => Array ( [0] => 3 [1] => Zdrowie i medycyna [2] => 0 ) )
Gdzie indeksy wygladaja tak: [0] - id kategorii, [1] - nazwa kategorii, [2] - parent
[0] => Array ( [0] => 2 [1] => Banki [2] => 0 )
[1] => Array ( [0] => 1 [1] => Internet i Telekomunikacja [2] => 0 )
[2] => Array ( [0] => 5 [1] => Kultura i Sztuka [2] => 0 )
[3] => Array ( [0] => 4 [1] => Motoryzacja [2] => 0 )
[4] => Array ( [0] => 10 [1] => Mot_podkat [2] => 4 )
[5] => Array ( [0] => 7 [1] => Podkat [2] => 1 )
[6] => Array ( [0] => 8 [1] => podkat 2 [2] => 1 )
[7] => Array ( [0] => 9 [1] => podkat2_1 [2] => 8 )
[8] => Array ( [0] => 6 [1] => Rozrywka i Gastronomia [2] => 0 )
[9] => Array ( [0] => 3 [1] => Zdrowie i medycyna [2] => 0 ) )
Gdzie indeksy wygladaja tak: [0] - id kategorii, [1] - nazwa kategorii, [2] - parent
I nie wiem jak teraz zorbic aby tablica byla posortowana najpierw wedlug nazwy kategorii - a nastepnie aby pod kategoria ktora ma podkategorie - byly wysietlane te jej podkategorie itd
Czyli zeby moja tablica zamiast powyzszej wygladala tak:
Kod
Array (
[0] => Array ( [0] => 2 [1] => Banki [2] => 0 )
[1] => Array ( [0] => 1 [1] => Internet i Telekomunikacja [2] => 0 )
[2] => Array ( [0] => 7 [1] => Podkat [2] => 1 )
[3] => Array ( [0] => 8 [1] => podkat 2 [2] => 1 )
[4] => Array ( [0] => 9 [1] => podkat2_1 [2] => 8 )
[5] => Array ( [0] => 5 [1] => Kultura i Sztuka [2] => 0 )
[6] => Array ( [0] => 4 [1] => Motoryzacja [2] => 0 )
[7] => Array ( [0] => 10 [1] => Mot_podkat [2] => 4 )
[8] => Array ( [0] => 6 [1] => Rozrywka i Gastronomia [2] => 0 )
[9] => Array ( [0] => 3 [1] => Zdrowie i medycyna [2] => 0 ) )
[0] => Array ( [0] => 2 [1] => Banki [2] => 0 )
[1] => Array ( [0] => 1 [1] => Internet i Telekomunikacja [2] => 0 )
[2] => Array ( [0] => 7 [1] => Podkat [2] => 1 )
[3] => Array ( [0] => 8 [1] => podkat 2 [2] => 1 )
[4] => Array ( [0] => 9 [1] => podkat2_1 [2] => 8 )
[5] => Array ( [0] => 5 [1] => Kultura i Sztuka [2] => 0 )
[6] => Array ( [0] => 4 [1] => Motoryzacja [2] => 0 )
[7] => Array ( [0] => 10 [1] => Mot_podkat [2] => 4 )
[8] => Array ( [0] => 6 [1] => Rozrywka i Gastronomia [2] => 0 )
[9] => Array ( [0] => 3 [1] => Zdrowie i medycyna [2] => 0 ) )
Mysle ze jak tablica bedzie wygaldala w taki sposob to drzewko sie juz aldie wysietli za pomoca SMARTY.
Z gory dzieki za pomoc