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 13533 Apr 17, 2005, 4:43 AM
Thread Re: [gotze] Active categories
Alba 12955 Apr 17, 2005, 5:33 AM
Thread Re: [Alba] Active categories
gotze 13000 Apr 17, 2005, 5:56 AM
Post Re: [gotze] Active categories
Alba 12941 Apr 17, 2005, 6:33 AM
Thread Active categories global
gotze 12883 Apr 23, 2005, 1:26 PM
Thread Re: [gotze] Active categories global
gotze 13032 Apr 23, 2005, 1:36 PM
Post Re: [gotze] Active categories global
gotze 12895 May 7, 2005, 7:00 PM
Thread Re: [gotze] Active categories
brewt 12904 May 9, 2005, 7:47 PM
Post Re: [brewt] Active categories
Payooo 12808 May 9, 2005, 11:47 PM
Thread Re: [brewt] Active categories
gotze 12840 May 10, 2005, 12:35 AM
Thread Re: [gotze] Active categories
brewt 12894 May 10, 2005, 12:47 AM
Post Re: [brewt] Active categories
Payooo 12843 May 10, 2005, 12:59 AM
Thread Re: [brewt] Active categories
gotze 12880 May 10, 2005, 1:04 AM
Thread Re: [gotze] Active categories
brewt 12842 May 10, 2005, 1:20 AM
Thread Re: [brewt] Active categories
brewt 12750 May 10, 2005, 1:23 AM
Thread Sorting
gotze 12846 May 10, 2005, 7:21 AM
Thread Re: [gotze] Sorting
Matthias70 12364 Sep 25, 2007, 1:48 PM
Thread Re: [Matthias70] Sorting
Andy 12438 Sep 26, 2007, 6:35 AM
Post Re: [Andy] Sorting
Matthias70 12351 Sep 26, 2007, 8:56 AM
Thread Re: [Andy] Sorting
Andy 12374 Sep 26, 2007, 9:09 AM
Thread Re: [Andy] Sorting
Matthias70 12341 Sep 26, 2007, 9:47 AM
Thread Re: [Matthias70] Sorting
Andy 12359 Sep 26, 2007, 9:51 AM
Thread Re: [Andy] Sorting
Matthias70 12308 Sep 26, 2007, 10:01 AM
Thread Re: [Matthias70] Sorting
Matthias70 12375 Sep 26, 2007, 10:24 AM
Thread Re: [Matthias70] Sorting
Matthias70 5606 Sep 26, 2007, 12:25 PM
Thread Re: [Matthias70] Sorting
Andy 5608 Sep 27, 2007, 1:03 AM
Thread Re: [Andy] Sorting
Matthias70 5630 Sep 27, 2007, 5:38 AM
Thread Re: [Matthias70] Sorting
Jesus 5546 Oct 2, 2007, 2:27 PM
Thread Re: [Jesus] Sorting
Matthias70 5582 Oct 2, 2007, 3:11 PM
Post Re: [Matthias70] Sorting
Jesus 5513 Oct 2, 2007, 11:11 PM
Thread Re: [Matthias70] Sorting
Matthias70 5373 Apr 13, 2008, 11:39 AM
Thread Re: [Matthias70] Sorting
Andy 5411 Apr 13, 2008, 12:03 PM
Thread Re: [Andy] Sorting
Matthias70 5443 Apr 13, 2008, 12:41 PM
Thread Re: [Matthias70] Sorting
Andy 5442 Apr 13, 2008, 1:29 PM
Thread Re: [Andy] Sorting
Matthias70 5373 Apr 13, 2008, 2:17 PM
Post Re: [Matthias70] Sorting
Andy 5355 Apr 14, 2008, 12:15 AM
Post Re: [brewt] Active categories
brewt 12792 May 10, 2005, 12:57 AM