Hi all,
Using the following global to list the 20 newest links:
sub {
my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY Add_Date DESC', 'LIMIT 20');
my $sth = $table->select;
my $output;
while (my $link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link', $link)
}
return $output;
}
Unfortunately, when the list appears, it contains links that have not been validated. How can the code be modified so as not to include the non-validated links?
Thanks.
Using the following global to list the 20 newest links:
sub {
my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY Add_Date DESC', 'LIMIT 20');
my $sth = $table->select;
my $output;
while (my $link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link', $link)
}
return $output;
}
Unfortunately, when the list appears, it contains links that have not been validated. How can the code be modified so as not to include the non-validated links?
Thanks.