sub { #Top 100 Links
my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY Hits DESC', 'LIMIT 100');
my $sth = $table->select;
my @output;
while (my $link = $sth->fetchrow_hashref) {
$tags->{totalhits} + = $link->{hits};
push (@output, $link);
}
return { top100_loop => \@output };
}

there is a column called hits, i try to calculate the total hit of selected links
but i get error. is there anything wrong


or if i could use calculation in tag? such as <%hits + $hits%>?

Hi,

You need to pass it back to the template =)

Try:


..and then call the total hits with : <%total_hits%>

..and change:


..to:


Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Hi Andy.

thank you for your help


after having a try. i was given a error

syntax error at (eval 58) line 12, near "} return" Global symbol "@output" requires explicit package name at (eval 58) line 12. Global symbol "$tags" requires explicit package name at (eval 58) line 12


what does it mean?

i got it

should be