Gossamer Forum
Quote Reply
All Links on one page
Hi

Few versions back we used the following global to list all links in one page.. this is no longer working with this version.. (getting internal error).

Can someone please point us to what is wrong..

sub {
# Displays all links on one page.
my ($output,$sth,$link);
my $search_db = $DB->table('Links');
$search_db->select_options ('ORDER BY ID DESC');
$sth = $search_db->select ( { isValidated => 'Yes' });
while ($link = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link_short', $link);
}
return $output;
}
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Quote Reply
Re: [katabd] All Links on one page In reply to
Hi,

Mmm.. can't see any reason why that wouldn't work. Try this version:

Code:
sub {
my $tbl = $DB->table('Links');
$tbl->select_options('ORDER BY ID DESC');
my $output;
my $sth = $tbl->select( { isValidated => 'Yes' } ) || die $GT::SQL::error;
while (my $hit = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display ('link_short', $hit);
}
return $output;
}

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] All Links on one page In reply to
Thank-s

Yours worked, mine- will not-.. no idea but thanks- as always-.
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory