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 6475 Nov 29, 2001, 3:52 PM
Thread Re: [Eraser] New Links Problem
Paul 6358 Nov 29, 2001, 3:57 PM
Thread Re: [PaulW] New Links Problem
brewt 6374 Nov 29, 2001, 4:31 PM
Post Re: [brewt] New Links Problem
Eraser 6429 Nov 29, 2001, 5:32 PM
Thread Re: [brewt] New Links Problem
Teambldr 6056 Mar 18, 2003, 10:11 AM
Thread Re: [Teambldr] New Links Problem
Paul 6065 Mar 18, 2003, 10:19 AM
Thread Re: [Paul] New Links Problem
Teambldr 6055 Mar 18, 2003, 10:29 AM
Post Re: [Teambldr] New Links Problem
Paul 6050 Mar 18, 2003, 10:32 AM
Thread Re: [Teambldr] New Links Problem
Paul 6079 Mar 18, 2003, 10:33 AM
Thread Re: [Paul] New Links Problem
Teambldr 6041 Mar 18, 2003, 10:37 AM
Thread Re: [Teambldr] New Links Problem
Paul 6042 Mar 18, 2003, 10:41 AM
Post Re: [Paul] New Links Problem
Teambldr 6029 Mar 18, 2003, 10:42 AM
Thread Re: [Paul] New Links Problem
Teambldr 6042 Mar 18, 2003, 3:50 PM
Thread Re: [Teambldr] New Links Problem
Paul 6017 Mar 18, 2003, 4:12 PM
Post Re: [Paul] New Links Problem
Teambldr 6001 Mar 18, 2003, 4:15 PM