Something like this should work;
Code:
sub {
my $ID = shift;
my (@_ids,@cat_titles);
my $table = $DB->table('CatLinks');
my $sth = $table->select( { LinkID => $ID } );
while (my $hit = $sth->fetchrow_hashref) {
push(@_ids,$hit->{CategoryID});
}
foreach (@_ids) {
my $table = $DB->table('Category');
my $sth = $table->select( { ID => $_ } );
while (my $hit = $sth->fetchrow_hashref) {
push(@cat_titles,$hit->{Title});
}
}
return join(", ",@cat_titles);
}
Call it with something like;
<%global_name($ID)%>
Untested, but the theory is beind it (if it doesn't work).
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!
