Hi Alex,
What about this (as Pugdog says above, you'll need mysql 3.23 or above)?
sub {
my $link_db = $DB->table('Links');
$link_db->select_options ("ORDER BY rand()","LIMIT 3");
my $sth = $link_db->select ({isFeatured=>'Yes', isValidated => 'Yes' });
my $output;
while (my $link = $sth->fetchrow_hashref){
$output .= Links::SiteHTML::display ('mini_link', $link);
}
return $output;
}
What about this (as Pugdog says above, you'll need mysql 3.23 or above)?
sub {
my $link_db = $DB->table('Links');
$link_db->select_options ("ORDER BY rand()","LIMIT 3");
my $sth = $link_db->select ({isFeatured=>'Yes', isValidated => 'Yes' });
my $output;
while (my $link = $sth->fetchrow_hashref){
$output .= Links::SiteHTML::display ('mini_link', $link);
}
return $output;
}