Gossamer Forum
Quote Reply
Active categories
I would like to have a listing of "active" categories, that is, categories containing new links.

I thought I could do something template-based with <%if Has_New_Links eq 'Yes'%> etc., but can't get it to work, and now think I need a global to do this. I've tried something like:

Code:
sub {
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY ID DESC');
$sth = $search_db->select ( { isNew => 'Yes', isValidated => 'Yes' });
while ($link = $sth->fetchrow_hashref) {
my $cat_db = $DB->table('Category');
my @root_cats = $cat_db->select ['Full_Name']->fetchall_list;
...

}
return $output;
}
... but can't get it right.

Can anyone help, please?

John
Subject Author Views Date
Thread Active categories gotze 13908 Apr 17, 2005, 4:43 AM
Thread Re: [gotze] Active categories
Alba 13254 Apr 17, 2005, 5:33 AM
Thread Re: [Alba] Active categories
gotze 13301 Apr 17, 2005, 5:56 AM
Post Re: [gotze] Active categories
Alba 13239 Apr 17, 2005, 6:33 AM
Thread Active categories global
gotze 13185 Apr 23, 2005, 1:26 PM
Thread Re: [gotze] Active categories global
gotze 13331 Apr 23, 2005, 1:36 PM
Post Re: [gotze] Active categories global
gotze 13193 May 7, 2005, 7:00 PM
Thread Re: [gotze] Active categories
brewt 13206 May 9, 2005, 7:47 PM
Post Re: [brewt] Active categories
Payooo 13106 May 9, 2005, 11:47 PM
Thread Re: [brewt] Active categories
gotze 13141 May 10, 2005, 12:35 AM
Thread Re: [gotze] Active categories
brewt 13195 May 10, 2005, 12:47 AM
Post Re: [brewt] Active categories
Payooo 13141 May 10, 2005, 12:59 AM
Thread Re: [brewt] Active categories
gotze 13179 May 10, 2005, 1:04 AM
Thread Re: [gotze] Active categories
brewt 13144 May 10, 2005, 1:20 AM
Thread Re: [brewt] Active categories
brewt 13051 May 10, 2005, 1:23 AM
Thread Sorting
gotze 13145 May 10, 2005, 7:21 AM
Thread Re: [gotze] Sorting
Matthias70 12664 Sep 25, 2007, 1:48 PM
Thread Re: [Matthias70] Sorting
Andy 12737 Sep 26, 2007, 6:35 AM
Post Re: [Andy] Sorting
Matthias70 12649 Sep 26, 2007, 8:56 AM
Thread Re: [Andy] Sorting
Andy 12674 Sep 26, 2007, 9:09 AM
Thread Re: [Andy] Sorting
Matthias70 12641 Sep 26, 2007, 9:47 AM
Thread Re: [Matthias70] Sorting
Andy 12661 Sep 26, 2007, 9:51 AM
Thread Re: [Andy] Sorting
Matthias70 12608 Sep 26, 2007, 10:01 AM
Thread Re: [Matthias70] Sorting
Matthias70 12673 Sep 26, 2007, 10:24 AM
Thread Re: [Matthias70] Sorting
Matthias70 5738 Sep 26, 2007, 12:25 PM
Thread Re: [Matthias70] Sorting
Andy 5738 Sep 27, 2007, 1:03 AM
Thread Re: [Andy] Sorting
Matthias70 5761 Sep 27, 2007, 5:38 AM
Thread Re: [Matthias70] Sorting
Jesus 5676 Oct 2, 2007, 2:27 PM
Thread Re: [Jesus] Sorting
Matthias70 5711 Oct 2, 2007, 3:11 PM
Post Re: [Matthias70] Sorting
Jesus 5642 Oct 2, 2007, 11:11 PM
Thread Re: [Matthias70] Sorting
Matthias70 5504 Apr 13, 2008, 11:39 AM
Thread Re: [Matthias70] Sorting
Andy 5544 Apr 13, 2008, 12:03 PM
Thread Re: [Andy] Sorting
Matthias70 5574 Apr 13, 2008, 12:41 PM
Thread Re: [Matthias70] Sorting
Andy 5572 Apr 13, 2008, 1:29 PM
Thread Re: [Andy] Sorting
Matthias70 5504 Apr 13, 2008, 2:17 PM
Post Re: [Matthias70] Sorting
Andy 5484 Apr 14, 2008, 12:15 AM
Post Re: [brewt] Active categories
brewt 13090 May 10, 2005, 12:57 AM