Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

: Links in a category and its sub categories

Quote Reply
: Links in a category and its sub categories
Hi

We have been using the following global to return a list of links in a category..

sub {
my $ID=shift;
my $table = $DB->table('CatLinks','Links');
my $sth = $table->select({ CategoryID => $ID, isValidated => 'Yes' } ) || return $GT::SQL::error;
my $output;
while (my $hit = $sth->fetchrow_hashref) {
$output.=qq~<li><a href="URLTO/detail_page.cgi?ID=$hit->{ID}">$hit->{Title}</a><br>$hit->{Description}~;
}
return $output;
}

How do we modify it to list the links in all the subcategories under that category..
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Quote Reply
Re: [katabd] : Links in a category and its sub categories In reply to
  
This post should give you the solution you're looking for.

http://www.gossamer-threads.com/...orum.cgi?post=277793

Regards,
Peter Puglisi
www.ausfreedom.com
Ultimate Freedom is our game.

Last edited by:

rocco: Apr 2, 2005, 11:13 PM
Quote Reply
Re: [rocco] : Links in a category and its sub categories In reply to
Thanks a lot.
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory