I'm assuming that all you want is a menu which has all the first level subcategories? If so, try this:
sub {
my $tags = shift;
my $cat_db = $DB->table('Category');
$cat_db->select_options ('ORDER BY full_name');
my $sth = $cat_db->select ( { FatherID => 0}, ['Full_Name','ID'] );
my $output="<table>";
while (my ($root_cat,$ID) = $sth->fetchrow_array) {
$output.="<tr><td>$root_cat</td></tr>";
my $sth2 = $cat_db->select ( { FatherID => $ID}, ['Full_Name','Name'] );
while (my ($cat,$short) = $sth2->fetchrow_array) {
my $url = $cat_db->as_url($cat);
$output .= qq~<tr><td><a href="$CFG->{build_root_url}/$url" class="toc"><b>$short</b></a></td></tr>~;
}
}
$output.="</table>";
return $output;
}
You'll need to play around with the presentation by modifying the html in red.
The UK High Street
sub {
my $tags = shift;
my $cat_db = $DB->table('Category');
$cat_db->select_options ('ORDER BY full_name');
my $sth = $cat_db->select ( { FatherID => 0}, ['Full_Name','ID'] );
my $output="<table>";
while (my ($root_cat,$ID) = $sth->fetchrow_array) {
$output.="<tr><td>$root_cat</td></tr>";
my $sth2 = $cat_db->select ( { FatherID => $ID}, ['Full_Name','Name'] );
while (my ($cat,$short) = $sth2->fetchrow_array) {
my $url = $cat_db->as_url($cat);
$output .= qq~<tr><td><a href="$CFG->{build_root_url}/$url" class="toc"><b>$short</b></a></td></tr>~;
}
}
$output.="</table>";
return $output;
}
You'll need to play around with the presentation by modifying the html in red.
The UK High Street