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 11421 Mar 30, 2001, 8:28 AM
Thread Re: Recent 10 links
katabd 11287 Mar 30, 2001, 9:02 AM
Post Re: Recent 10 links
SamX 11265 Mar 30, 2001, 9:38 AM
Thread Re: Recent 10 links
fabio 11237 Apr 3, 2001, 2:08 AM
Thread Re: Recent 10 links
Eraser 11206 Apr 3, 2001, 6:04 AM
Post Re: Recent 10 links
fabio 11186 Apr 3, 2001, 6:58 AM
Thread Re: Recent 10 links
Sir Up 11255 Apr 6, 2001, 1:45 PM
Thread Re: Recent 10 links
Robert 11180 Apr 16, 2001, 12:57 PM
Thread Re: Recent 10 links
Sir Up 11153 Apr 16, 2001, 1:14 PM
Thread Re: Recent 10 links
recon 11019 Aug 17, 2001, 1:48 PM
Thread Re: Recent 10 links
katabd 10932 Aug 24, 2001, 2:28 AM
Thread Re: Recent 10 links
Beck 10927 Aug 24, 2001, 8:32 PM
Thread Re: Recent 10 links
Paul 10986 Aug 24, 2001, 9:01 PM
Post Re: Recent 10 links
Beck 10936 Aug 24, 2001, 9:18 PM
Thread Re: [katabd] Recent 10 links
FindSP.com 9915 Feb 18, 2005, 6:28 AM
Thread Re: [FindSP.com] Recent 10 links
HopeForYou 9377 Jun 1, 2009, 7:59 PM
Thread Re: [HopeForYou] Recent 10 links
Andy 9412 Jun 1, 2009, 11:45 PM
Post Re: [Andy] Recent 10 links
HopeForYou 9387 Jun 2, 2009, 7:26 AM