Gossamer Forum
Quote Reply
Random global
Hi, I'd like to get this global changed so that it only fetches validated listings:

Code:

sub {
my $tags = shift;
my $link_db = $DB->table('Links','CatLinks');
my $cat_id = $tags->{Random_CatID};
my $limit = $tags->{Random_Limit} || 1;
my (@output, $sth);
$link_db->select_options ('ORDER BY RAND()', "LIMIT $limit");
if ($cat_id) {
$sth = $link_db->select ( { CategoryID => $cat_id });
}
else {
$sth = $link_db->select;
}while (my $hash = $sth->fetchrow_hashref) {
push @output, $hash;
}return { Random_Loop => \@output }
}

cdkrg

Able2Know :: Ajooja Directory
Subject Author Views Date
Thread Random global cdkrg 2850 Jul 24, 2004, 9:10 PM
Thread Re: [cdkrg] Random global
minesite 2792 Jul 24, 2004, 10:18 PM
Thread Re: [minesite] Random global
cdkrg 2782 Jul 26, 2004, 4:38 AM
Thread Re: [cdkrg] Random global
minesite 2799 Jul 26, 2004, 4:53 AM
Thread Re: [minesite] Random global
cdkrg 2770 Jul 27, 2004, 10:40 PM
Thread Re: [cdkrg] Random global
minesite 2765 Jul 27, 2004, 10:50 PM
Post Re: [minesite] Random global
Dorette 2713 Feb 7, 2005, 1:29 PM