Gossamer Forum
Quote Reply
New Links Problem
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
Subject Author Views Date
Thread New Links Problem Eraser 6369 Nov 29, 2001, 3:52 PM
Thread Re: [Eraser] New Links Problem
Paul 6254 Nov 29, 2001, 3:57 PM
Thread Re: [PaulW] New Links Problem
brewt 6270 Nov 29, 2001, 4:31 PM
Post Re: [brewt] New Links Problem
Eraser 6325 Nov 29, 2001, 5:32 PM
Thread Re: [brewt] New Links Problem
Teambldr 5952 Mar 18, 2003, 10:11 AM
Thread Re: [Teambldr] New Links Problem
Paul 5961 Mar 18, 2003, 10:19 AM
Thread Re: [Paul] New Links Problem
Teambldr 5952 Mar 18, 2003, 10:29 AM
Post Re: [Teambldr] New Links Problem
Paul 5947 Mar 18, 2003, 10:32 AM
Thread Re: [Teambldr] New Links Problem
Paul 5975 Mar 18, 2003, 10:33 AM
Thread Re: [Paul] New Links Problem
Teambldr 5938 Mar 18, 2003, 10:37 AM
Thread Re: [Teambldr] New Links Problem
Paul 5938 Mar 18, 2003, 10:41 AM
Post Re: [Paul] New Links Problem
Teambldr 5926 Mar 18, 2003, 10:42 AM
Thread Re: [Paul] New Links Problem
Teambldr 5939 Mar 18, 2003, 3:50 PM
Thread Re: [Teambldr] New Links Problem
Paul 5914 Mar 18, 2003, 4:12 PM
Post Re: [Paul] New Links Problem
Teambldr 5898 Mar 18, 2003, 4:15 PM