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 11571 Mar 30, 2001, 8:28 AM
Thread Re: Recent 10 links
katabd 11437 Mar 30, 2001, 9:02 AM
Post Re: Recent 10 links
SamX 11414 Mar 30, 2001, 9:38 AM
Thread Re: Recent 10 links
fabio 11387 Apr 3, 2001, 2:08 AM
Thread Re: Recent 10 links
Eraser 11357 Apr 3, 2001, 6:04 AM
Post Re: Recent 10 links
fabio 11334 Apr 3, 2001, 6:58 AM
Thread Re: Recent 10 links
Sir Up 11406 Apr 6, 2001, 1:45 PM
Thread Re: Recent 10 links
Robert 11332 Apr 16, 2001, 12:57 PM
Thread Re: Recent 10 links
Sir Up 11304 Apr 16, 2001, 1:14 PM
Thread Re: Recent 10 links
recon 11169 Aug 17, 2001, 1:48 PM
Thread Re: Recent 10 links
katabd 11084 Aug 24, 2001, 2:28 AM
Thread Re: Recent 10 links
Beck 11078 Aug 24, 2001, 8:32 PM
Thread Re: Recent 10 links
Paul 11136 Aug 24, 2001, 9:01 PM
Post Re: Recent 10 links
Beck 11085 Aug 24, 2001, 9:18 PM
Thread Re: [katabd] Recent 10 links
FindSP.com 10064 Feb 18, 2005, 6:28 AM
Thread Re: [FindSP.com] Recent 10 links
HopeForYou 9526 Jun 1, 2009, 7:59 PM
Thread Re: [HopeForYou] Recent 10 links
Andy 9563 Jun 1, 2009, 11:45 PM
Post Re: [Andy] Recent 10 links
HopeForYou 9536 Jun 2, 2009, 7:26 AM