Hi adultdvdlinks

You could try this <%top10%>

sub {
#Top 10 sites by hits.
my ($output,$sth,$link);
my $id = shift;
my $db = $DB->table ('Links');
$db->select_options ('ORDER BY Hits DESC', 'LIMIT 10');
my $sth = $db->select ( { isValidated => 'Yes'} );
my $premium;
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link1', $link);
}
return $output;
}

Call it via

<%top10%>
<%loop top10_loop%>
<%endloop%>

and make up the link1.html template, it would look something like this:

<a class="link" href="<%db_cgi_url%>/jump.cgi?ID=<%ID%>">
<%Title%>: with <%Hits%> hits.</a>

Regards

minesite