Smarty

[Crazy-]

I'm busy with a howto section on my site with Cats and sub-cats

but now i don't get the subcats under de cats:

[php:1:f9f6ce128d]$DB->uitvoeren("SELECT * FROM howtos_cats");
while($howtos_cats_array = $DB->uitlezen()) {

$cats[] = array(
'cat_naam' => $howtos_cats_array['cat_naam'],
'cat_pic' => "/images/howtos/".$howtos_cats_array['pic'],
);

// haal de subcats eruit
$DB2->uitvoeren("SELECT * FROM howtos_sub_cats WHERE cat_id = $howtos_cats_array[id]");
while($howtos_subcats_array = $DB2->uitlezen()) {

$sub_cats[] = array(
'sub_naam' => $howtos_subcats_array['sub_naam'],
);
}
}

// maak het klaar voor de template
$so->assign("cats",$cats);
$so->assign("sub_cats",$sub_cats);[/php:1:f9f6ce128d]

and the template

[boots]

{section} is for indexed arrays. You want {foreach} which works with associative arrays.

[Crazy-]

can you explain it a little bit ?

[boots]

I think my reply was hasty

it looks like your subcats is not 2 dimensional. perhaps something like this

$sub_cats[$i][] = array( 'sub_naam' => $howtos_subcats_array['sub_naam']);

and $i starts at 0 and is incremented for each new cat

[Crazy-]

stupid me !

you're right

thnx a lot

[Crazy-]

hm, when i put a howto under a subcat, the ID is +1

so:

howto: subcat_id = 1

then it is showed under sucat_id 2 !

[Crazy-]

somebody?