Hi Andy,
I just added this to MJBs global, but I'm getting an error.
Can you please have a look at it?
Code:
sub {
my $tags = shift;
my $table = $DB->table('Links','Reviews');
$table->select_options ('ORDER BY Review_WasHelpful DESC', 'LIMIT 5');
$sth = $search_db->select
( { isValidated => "Yes" } , { Review_Validated => 'Yes' }); while (my $link = $sth->fetchrow_hashref()) {
my @output;
while (my $link = $sth->fetchrow_hashref) {
push (@output, $link);
}
return { top_reviews_loop => \@output };
}
Unable to compile 'top_reviews': Global symbol "$sth" requires explicit package name at (eval 41) line 5. Global symbol "$search_db" requires explicit package name at (eval 41) line 5. Global symbol "$sth" requires explicit package name at (eval 41) line 6. Global symbol "$sth" requires explicit package name at (eval 41) line 8. Missing right curly or square bracket at (eval 41) line 12, at end of line syntax error at (eval 41) line 12, at EOF
Matthias
gpaed.de