You could try something like;
<%global_name($ID)%> (this will work in link.html).
my $ID = $_[0];
my $FATHERID = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $ID } )->fetchrow;
my $name = $DB->table('Category')->select( ['Name'], { ID => $FATHERID })->fetchrow;
$name ? return $name : return 'No name found';
}
Hope that helps.
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!
<%global_name($ID)%> (this will work in link.html).
Code:
sub { my $ID = $_[0];
my $FATHERID = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $ID } )->fetchrow;
my $name = $DB->table('Category')->select( ['Name'], { ID => $FATHERID })->fetchrow;
$name ? return $name : return 'No name found';
}
Hope that helps.
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!