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 14067 Mar 30, 2001, 8:28 AM
Thread Re: Recent 10 links
katabd 13891 Mar 30, 2001, 9:02 AM
Post Re: Recent 10 links
SamX 13847 Mar 30, 2001, 9:38 AM
Thread Re: Recent 10 links
fabio 13836 Apr 3, 2001, 2:08 AM
Thread Re: Recent 10 links
Eraser 13807 Apr 3, 2001, 6:04 AM
Post Re: Recent 10 links
fabio 13762 Apr 3, 2001, 6:58 AM
Thread Re: Recent 10 links
Sir Up 13858 Apr 6, 2001, 1:45 PM
Thread Re: Recent 10 links
Robert 13780 Apr 16, 2001, 12:57 PM
Thread Re: Recent 10 links
Sir Up 13752 Apr 16, 2001, 1:14 PM
Thread Re: Recent 10 links
recon 13623 Aug 17, 2001, 1:48 PM
Thread Re: Recent 10 links
katabd 13540 Aug 24, 2001, 2:28 AM
Thread Re: Recent 10 links
Beck 13531 Aug 24, 2001, 8:32 PM
Thread Re: Recent 10 links
Paul 13586 Aug 24, 2001, 9:01 PM
Post Re: Recent 10 links
Beck 13519 Aug 24, 2001, 9:18 PM
Thread Re: [katabd] Recent 10 links
FindSP.com 12512 Feb 18, 2005, 6:28 AM
Thread Re: [FindSP.com] Recent 10 links
HopeForYou 11967 Jun 1, 2009, 7:59 PM
Thread Re: [HopeForYou] Recent 10 links
Andy 12002 Jun 1, 2009, 11:45 PM
Post Re: [Andy] Recent 10 links
HopeForYou 11970 Jun 2, 2009, 7:26 AM