Hi webslicer, I picked it up somewhere on the forum but can't find it anymore :P
Here it is, I copied it from my global section:
Code:
sub { my $db = $DB->table('SearchLog');
my $x = 5;
my $output; $db->select_options("ORDER BY HitCount DESC", "LIMIT $x");
my $sth = $db->select('Term'); while (my $res = $sth->fetchrow_hashref) {
$output .= qq|<a href="$CFG->{db_cgi_url}/search.cgi?query=$res->{Term}">$res->{Term}</a><br>|;} return $output; } Regards, Rik