sub {

my $link_id = $_[0];

my $cat_id = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $link_id } )->fetchrow;
my $cat_name = $DB->table('Category')->select( ['Full_Name'], { ID => $cat_id } )->fetchrow;

my $cat_url = $CFG->{build_root_url} . '/' . $DB->table('Category')->as_url( $cat_name ) . '/' . $CFG->{build_index};

return { CategoryName => $cat_name, CategoryURL => $cat_url }

}

<%get_category_details($ID)%>
In category: <a href="<%CategoryURL%>"><%CategoryName%></a>

sub {

my $link_id = $_[0];

my $cat_id = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $link_id } )->fetchrow;
my @cat_name_split = split /\//, $DB->table('Category')->select( ['Full_Name'], { ID => $cat_id } )->fetchrow;

return { CategoryName => join(',',@cat_name_split) }

}

<meta name="keywords" content="<%get_cat_keywords($ID)%>" />

return { CategoryName => join(',',@cat_name_split) }

return join(',',@cat_name_split)