Hi,
Try tihs global.
get_category_details
Code:
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 }
}
Call with:
Code:
<%get_category_details($ID)%>
In category: <a href="<%CategoryURL%>"><%CategoryName%></a>
Untested, but should do the trick =)
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my
Amazon Wish List GLinks ULTRA Package | GLinks ULTRA Package PRO Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin |
Pre-Made Template Sets |
FREE GLinks Plugins!