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?
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!