You could try;
<%global_name($ID)%>
... in category.html (with the meta_description stuff).
... and put the following code into a global;
my $ID $_[0];
my $table = $DB->table('CatLinks','Links');
my $sth = $table->( { CategoryID => $ID }, { isValidated => 'Yes' } ) || return $GT::SQL::error;
my @titles;
while (my $hit = $sth->fetchrow_hashref) {
push(@titles,$hit->{Title});
}
return join(",",@titles);
}
This is untested, and it is 8:30am, so please be warned that it may not work completly as it is meant to :)
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)%>
... in category.html (with the meta_description stuff).
... and put the following code into a global;
Code:
sub { my $ID $_[0];
my $table = $DB->table('CatLinks','Links');
my $sth = $table->( { CategoryID => $ID }, { isValidated => 'Yes' } ) || return $GT::SQL::error;
my @titles;
while (my $hit = $sth->fetchrow_hashref) {
push(@titles,$hit->{Title});
}
return join(",",@titles);
}
This is untested, and it is 8:30am, so please be warned that it may not work completly as it is meant to :)
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!