Gossamer Forum
Quote Reply
Re: Recent 10 links In reply to
hi
I think the following should do
sub {
# Displays the Newest links.
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY ADD_DATE DESC Limit 10');
$sth = $search_db->select ( { isNew => 'Yes'});
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link', $link);
}
return $output;
}

Regards
Abd

http://www.idleb.com
Subject Author Views Date
Thread Recent 10 links SamX 11425 Mar 30, 2001, 8:28 AM
Thread Re: Recent 10 links
katabd 11291 Mar 30, 2001, 9:02 AM
Post Re: Recent 10 links
SamX 11269 Mar 30, 2001, 9:38 AM
Thread Re: Recent 10 links
fabio 11241 Apr 3, 2001, 2:08 AM
Thread Re: Recent 10 links
Eraser 11210 Apr 3, 2001, 6:04 AM
Post Re: Recent 10 links
fabio 11190 Apr 3, 2001, 6:58 AM
Thread Re: Recent 10 links
Sir Up 11259 Apr 6, 2001, 1:45 PM
Thread Re: Recent 10 links
Robert 11184 Apr 16, 2001, 12:57 PM
Thread Re: Recent 10 links
Sir Up 11157 Apr 16, 2001, 1:14 PM
Thread Re: Recent 10 links
recon 11023 Aug 17, 2001, 1:48 PM
Thread Re: Recent 10 links
katabd 10937 Aug 24, 2001, 2:28 AM
Thread Re: Recent 10 links
Beck 10931 Aug 24, 2001, 8:32 PM
Thread Re: Recent 10 links
Paul 10990 Aug 24, 2001, 9:01 PM
Post Re: Recent 10 links
Beck 10940 Aug 24, 2001, 9:18 PM
Thread Re: [katabd] Recent 10 links
FindSP.com 9919 Feb 18, 2005, 6:28 AM
Thread Re: [FindSP.com] Recent 10 links
HopeForYou 9381 Jun 1, 2009, 7:59 PM
Thread Re: [HopeForYou] Recent 10 links
Andy 9416 Jun 1, 2009, 11:45 PM
Post Re: [Andy] Recent 10 links
HopeForYou 9391 Jun 2, 2009, 7:26 AM