Ah, I see what you mean now =)
Try the same global (you can call it the same way too), with;
my $ID = $_[0];
my $FATHERID = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $ID } )->fetchrow;
my $name = $DB->table('Category')->select( ['Full_Name'], { ID => $FATHERID })->fetchrow;
my @name_slice = split /\//, $name;
$name_slice[0] ? return $name_slice[0] : return 'No name found'; }
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!
Try the same global (you can call it the same way too), with;
Code:
sub { my $ID = $_[0];
my $FATHERID = $DB->table('CatLinks')->select( ['CategoryID'], { LinkID => $ID } )->fetchrow;
my $name = $DB->table('Category')->select( ['Full_Name'], { ID => $FATHERID })->fetchrow;
my @name_slice = split /\//, $name;
$name_slice[0] ? return $name_slice[0] : return 'No name found'; }
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!