Quote:
Don't ask for much do you.If it's worth doing then it's worth doing well!
I tried this. Changed the prefix to that of the db tables I want it to look at and it returns nothing. No error, but no result either.
rank_total
Quote:
sub { my $table = $DB->table('Reviews','Links');
$table->select_options ("GROUP BY Review_LinkID", "ORDER BY total DESC", "LIMIT 10");
my $sth = $table->select(['SUM(Review_Rating) AS total','kb_Links.*']);
my $output;
while (my $rec=$sth->fetchrow_hashref){
$output .= "<li>$rec->{'Title'} ($rec->{'total'})";
}
return $output;
}
Thanks!
Safe swoops
Sangiro