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

Re: [Evoir] Random Global Questions

Quote Reply
Re: [Evoir] Random Global Questions In reply to
 You could try adding this before your return line:


my $cat_db = $DB->table('Category');
my $sth2 = $cat_db->select ( ['ID'],{ FatherID => $cat_id });

while (my ($child_id) = $sth2->fetchrow_array){
my $sth3 = $link_db->select ( { CategoryID => $child_id, isValidated => 'Yes' });
while (my $hash2 = $sth3->fetchrow_hashref) {
push @output, $hash2;

}
}

This is modified from one of my globals so I haven't tested it.

Laura.
The UK High Street
Subject Author Views Date
Thread Random Global Questions Evoir 6909 Aug 2, 2002, 4:34 PM
Thread Re: [Evoir] Random Global Questions
afinlr 6787 Aug 2, 2002, 5:14 PM
Thread Re: [afinlr] Random Global Questions
Evoir 6864 Aug 3, 2002, 9:24 AM
Thread Re: [Evoir] Random Global Questions
afinlr 6806 Aug 3, 2002, 11:22 AM
Post Re: [afinlr] Random Global Questions
Evoir 6773 Aug 3, 2002, 11:49 AM
Thread Re: [afinlr] Random Global Questions
Paul 6784 Aug 3, 2002, 11:56 AM
Thread Re: [Paul] Random Global Questions
Evoir 6797 Aug 3, 2002, 12:02 PM
Thread Re: [Evoir] Random Global Questions
afinlr 6725 Aug 3, 2002, 12:52 PM
Thread Re: [afinlr] Random Global Questions
Evoir 6727 Aug 7, 2002, 1:08 PM
Post Re: [Evoir] Random Global Questions
Evoir 6666 Aug 8, 2002, 2:45 PM
Thread Re: [Paul] Random Global Questions
afinlr 6754 Aug 3, 2002, 12:18 PM
Thread Re: [afinlr] Random Global Questions
Paul 6805 Aug 3, 2002, 12:43 PM
Thread Re: [Paul] Random Global Questions
Evoir 6675 Sep 13, 2002, 11:41 AM
Thread Re: [Evoir] Random Global Questions
Alex 6717 Sep 13, 2002, 12:34 PM
Thread Re: [Alex] Random Global Questions
Evoir 6630 Sep 13, 2002, 12:49 PM
Thread Re: [Evoir] Random Global Questions
Alex 6655 Sep 13, 2002, 1:42 PM
Post Re: [Alex] Random Global Questions
afinlr 6596 Sep 13, 2002, 3:37 PM
Post Re: [Alex] Random Global Questions
Evoir 6602 Sep 13, 2002, 4:34 PM
Post Re: [Alex] Random Global Questions
Evoir 6591 Sep 13, 2002, 4:37 PM
Post Re: [Alex] Random Global Questions
Evoir 6637 Sep 13, 2002, 4:56 PM