(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [SSmeredith] last links added aka newest links: Edit Log

Here is the list of edits for this post
Jan 16, 2003, 12:14 PM
Paul
Veteran (19537 posts)
Jan 16, 2003, 12:14 PM
Views: 4841
Re: [SSmeredith] last links added aka newest links
This should do it...

Code:
sub {
my $link_db = $DB->table ('Links');
$link_db->select_options ('ORDER BY ID DESC', 'LIMIT 6');
my $links = $link_db->select('DISTINCT(Title)', 'ID', { isNew => "Yes", isValidated => "Yes" } )->fetchall_arrayref;
return join ("<br>", map { qq|<a href="$CFG->{db_cgi_url}/ppc_jump.cgi?ID=$_->[1]">$_->[0]</a>| }@$links);
}

Last edited by:

Paul: Jan 16, 2003, 12:16 PM

Edit Log: