The following code displays new links on a page.
The problem is that links are displayed BEFORE they are validated.
Any suggestions on how to make only links that have been validated display?
sub {
# Displays the last 9 links.
my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY Add_Date DESC', 'LIMIT 9');
my $sth = $table->select;
my @output;
while (my $link = $sth->fetchrow_hashref) {
$link->{Title} = (length $link->{Title} > 28) ? substr($link->{Title},0,28) . ' ...' : $link->{Title};
push (@output, $link);
}
return { New_Links_loop => \@output };
}
~ ERASER
Free JavaScripts @ Insight Eye
The problem is that links are displayed BEFORE they are validated.
Any suggestions on how to make only links that have been validated display?
sub {
# Displays the last 9 links.
my $tags = shift;
my $table = $DB->table('Links');
$table->select_options ('ORDER BY Add_Date DESC', 'LIMIT 9');
my $sth = $table->select;
my @output;
while (my $link = $sth->fetchrow_hashref) {
$link->{Title} = (length $link->{Title} > 28) ? substr($link->{Title},0,28) . ' ...' : $link->{Title};
push (@output, $link);
}
return { New_Links_loop => \@output };
}
~ ERASER
Free JavaScripts @ Insight Eye