Gossamer Forum
Quote Reply
Re: [Matthias70] Sorting In reply to
Try this:

Code:
sub {
my $category = $DB->table('Category');
$category->select_options('ORDER BY Name');
my $sth = $category->select( ['Has_New_Links','Number_of_Links','Name','Full_Name'], GT::SQL::Condition->new('FatherID','>','0','CatDepth','=','1') );
my @cats;
while (my $cat = $sth->fetchrow_hashref) {
$cat->{URL} = $category->as_url($cat->{Full_Name}) . "/$CFG->{build_index}";
push @cats, $cat;
}
return { new_categories => \@cats };
}

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!

Last edited by:

Andy: Apr 13, 2008, 1:28 PM
Subject Author Views Date
Thread Active categories gotze 13883 Apr 17, 2005, 4:43 AM
Thread Re: [gotze] Active categories
Alba 13233 Apr 17, 2005, 5:33 AM
Thread Re: [Alba] Active categories
gotze 13280 Apr 17, 2005, 5:56 AM
Post Re: [gotze] Active categories
Alba 13218 Apr 17, 2005, 6:33 AM
Thread Active categories global
gotze 13163 Apr 23, 2005, 1:26 PM
Thread Re: [gotze] Active categories global
gotze 13310 Apr 23, 2005, 1:36 PM
Post Re: [gotze] Active categories global
gotze 13172 May 7, 2005, 7:00 PM
Thread Re: [gotze] Active categories
brewt 13185 May 9, 2005, 7:47 PM
Post Re: [brewt] Active categories
Payooo 13085 May 9, 2005, 11:47 PM
Thread Re: [brewt] Active categories
gotze 13120 May 10, 2005, 12:35 AM
Thread Re: [gotze] Active categories
brewt 13174 May 10, 2005, 12:47 AM
Post Re: [brewt] Active categories
Payooo 13120 May 10, 2005, 12:59 AM
Thread Re: [brewt] Active categories
gotze 13158 May 10, 2005, 1:04 AM
Thread Re: [gotze] Active categories
brewt 13123 May 10, 2005, 1:20 AM
Thread Re: [brewt] Active categories
brewt 13030 May 10, 2005, 1:23 AM
Thread Sorting
gotze 13124 May 10, 2005, 7:21 AM
Thread Re: [gotze] Sorting
Matthias70 12643 Sep 25, 2007, 1:48 PM
Thread Re: [Matthias70] Sorting
Andy 12716 Sep 26, 2007, 6:35 AM
Post Re: [Andy] Sorting
Matthias70 12628 Sep 26, 2007, 8:56 AM
Thread Re: [Andy] Sorting
Andy 12653 Sep 26, 2007, 9:09 AM
Thread Re: [Andy] Sorting
Matthias70 12620 Sep 26, 2007, 9:47 AM
Thread Re: [Matthias70] Sorting
Andy 12639 Sep 26, 2007, 9:51 AM
Thread Re: [Andy] Sorting
Matthias70 12587 Sep 26, 2007, 10:01 AM
Thread Re: [Matthias70] Sorting
Matthias70 12652 Sep 26, 2007, 10:24 AM
Thread Re: [Matthias70] Sorting
Matthias70 5736 Sep 26, 2007, 12:25 PM
Thread Re: [Matthias70] Sorting
Andy 5736 Sep 27, 2007, 1:03 AM
Thread Re: [Andy] Sorting
Matthias70 5759 Sep 27, 2007, 5:38 AM
Thread Re: [Matthias70] Sorting
Jesus 5674 Oct 2, 2007, 2:27 PM
Thread Re: [Jesus] Sorting
Matthias70 5709 Oct 2, 2007, 3:11 PM
Post Re: [Matthias70] Sorting
Jesus 5640 Oct 2, 2007, 11:11 PM
Thread Re: [Matthias70] Sorting
Matthias70 5502 Apr 13, 2008, 11:39 AM
Thread Re: [Matthias70] Sorting
Andy 5542 Apr 13, 2008, 12:03 PM
Thread Re: [Andy] Sorting
Matthias70 5572 Apr 13, 2008, 12:41 PM
Thread Re: [Matthias70] Sorting
Andy 5570 Apr 13, 2008, 1:29 PM
Thread Re: [Andy] Sorting
Matthias70 5502 Apr 13, 2008, 2:17 PM
Post Re: [Matthias70] Sorting
Andy 5482 Apr 14, 2008, 12:15 AM
Post Re: [brewt] Active categories
brewt 13069 May 10, 2005, 12:57 AM