woo hoo, got it!
sub {
#return the Full_Name for a category based on the category_id available in browser_category.html
my $cat;
my ($rec) = @_;
my $category_id = $rec->{category_id};
my ($cat) = $DB->table('Category')->select(['Full_Name'],{' ID' => $category_id})->fetchrow_array;
return $cat;
}
I now just need to tweak it so it can show a condensed version of this ie:
Travel and Tourism/.../Ontario/Niagra
(Top level and last two only)
Code:
sub {
#return the Full_Name for a category based on the category_id available in browser_category.html
my $cat;
my ($rec) = @_;
my $category_id = $rec->{category_id};
my ($cat) = $DB->table('Category')->select(['Full_Name'],{' ID' => $category_id})->fetchrow_array;
return $cat;
}
I now just need to tweak it so it can show a condensed version of this ie:
Travel and Tourism/.../Ontario/Niagra
(Top level and last two only)