Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [anup123] Last 10 Added

Quote Reply
Re: [anup123] Last 10 Added In reply to
Quote:
Last 10 added (all categories composite summary on home page and Category Wise Summary on Category Page). The text should be truncated much like what's there on the above link so that the same fits within a given tablewidth... The link url should be configurable either to the Detailed Proifile or to the <%URL%>

You don't ask for much, do you? Tongue

I can't help you with all of that, as I'm a bit pushed for time. However, something like this should do it;

Code:
sub {

my $tbl = $DB->table('Links');
$tbl->select_options('ORDER BY TimeStmp DESC','LIMIT 10');
my $sth = $tbl->select() || return $GT::SQL::error;
my $back;
while (my $hit = $sth->fetchrow_hashref) {
$back .= Links::SiteHTML::display('link',$hit);
}
return $back;
}

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Last 10 Added anup123 5366 Aug 9, 2004, 12:25 AM
Thread Re: [anup123] Last 10 Added
Andy 5283 Aug 9, 2004, 1:19 AM
Post Re: [Andy] Last 10 Added
anup123 5235 Aug 9, 2004, 1:54 PM
Thread Re: [anup123] Last 10 Added
minesite 5262 Aug 9, 2004, 1:58 AM
Thread Re: [minesite] Last 10 Added
anup123 5270 Aug 9, 2004, 3:26 PM
Thread Re: [anup123] Last 10 Added
DogTags 5218 Aug 12, 2004, 4:57 AM
Post Re: [DogTags] Last 10 Added
anup123 5187 Aug 12, 2004, 5:32 AM
Thread Re: [DogTags] Last 10 Added
minesite 5197 Aug 12, 2004, 5:34 AM
Thread Re: [minesite] Last 10 Added
afinlr 5210 Aug 13, 2004, 8:26 AM
Post Re: [afinlr] Last 10 Added
anup123 5215 Aug 13, 2004, 8:37 AM
Thread Re: [afinlr] Last 10 Added
minesite 5201 Aug 13, 2004, 9:07 AM
Thread Re: [minesite] Last 10 Added
afinlr 5184 Aug 13, 2004, 9:13 AM
Post Re: [afinlr] Last 10 Added
minesite 5164 Aug 13, 2004, 9:38 AM