Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Andy] Subcategories by ID?

Quote Reply
Re: [Andy] Subcategories by ID? In reply to
Oh, it shows many, many... links to "cat 50".

What did I make wrong?

I have insert this:
Code:
sub {

my $cat = $_[0];
my $db_obj = $DB->table('Category');
$db_obj->select_options ('ORDER BY Full_Name DESC');

my $sth = $db_obj->select ( FatherID => $_[0] ) || die $GT::SQL::error;

my @cats;
while (my $hit = $sth->fetchrow_hashref) {
$hit->{URL} = $CFG->{build_root_url} . "/" . $DB->table('Category')->as_url( $hit->{Full_Name} ) . "/" . $CFG->{build_index};
push @cats, $hit;
}

return { cats_loop => \@cats }

}
in:
get_cats_in_other

Knubbel
Subject Author Views Date
Thread; hot thread Subcategories by ID? Knubbel 8702 Jul 7, 2008, 6:23 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8555 Jul 7, 2008, 7:13 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8552 Jul 7, 2008, 7:23 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8524 Jul 7, 2008, 7:29 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8533 Jul 7, 2008, 7:36 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8563 Jul 7, 2008, 7:43 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8516 Jul 7, 2008, 8:01 AM
Post; hot thread Re: [Knubbel] Subcategories by ID?
Knubbel 8511 Jul 7, 2008, 8:09 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8552 Jul 7, 2008, 8:09 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8518 Jul 7, 2008, 8:23 AM
Post; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8524 Jul 7, 2008, 8:25 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8515 Jul 7, 2008, 8:31 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Knubbel 8505 Jul 7, 2008, 10:44 PM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8494 Jul 7, 2008, 11:31 PM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8500 Jul 7, 2008, 11:46 PM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8519 Jul 7, 2008, 11:56 PM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8509 Jul 8, 2008, 12:21 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8510 Jul 8, 2008, 12:26 AM
Thread; hot thread Post deleted by Knubbel
Knubbel 8487 Jul 8, 2008, 12:36 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8503 Jul 8, 2008, 12:39 AM
Thread; hot thread Post deleted by Knubbel
Knubbel 8500 Jul 8, 2008, 12:47 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8554 Jul 8, 2008, 12:54 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Andy 8498 Jul 8, 2008, 1:14 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 8466 Jul 8, 2008, 2:04 AM
Thread; hot thread Re: [Knubbel] Subcategories by ID?
Andy 8462 Jul 8, 2008, 2:07 AM
Thread; hot thread Re: [Andy] Subcategories by ID?
Knubbel 1578 Jul 8, 2008, 2:18 AM
Post; hot thread Re: [Knubbel] Subcategories by ID?
Andy 1579 Jul 8, 2008, 2:20 AM