Mmm.. try this in detailed.html;
my $ID = $_[0];
my $table = $DB->table ('CatLinks','Category');
$table->select_options('LIMIT 1');
my $name = $table->select ( ['Name'], { LinkID => $ID } )->fetchrow;
return $name;
}
..and call with;
<%global_name($ID)%>
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!
Code:
sub { my $ID = $_[0];
my $table = $DB->table ('CatLinks','Category');
$table->select_options('LIMIT 1');
my $name = $table->select ( ['Name'], { LinkID => $ID } )->fetchrow;
return $name;
}
..and call with;
<%global_name($ID)%>
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!