OK, so now I have the following and I get an internal server error:
#!/usr/local/bin/perl
#================================
use strict;
use lib '/var/home/moen/wiredbiz.com/cgi-bin/links/admin';
use Links qw/$DB $IN $CFG/;
Links::init('/var/home/moen/wiredbiz.com/cgi-bin/links/admin');
use Links::SiteHTML;
local $SIG{__DIE__} = \&Links::fatal;
main();
sub main {
#---------------------------------------------------
#
my $pageNum = $IN->param('nh') || 1;
# number of links per page
my $linksPP = 10;
my $start = $linksPP*$pageNum - $linksPP;
my ($sth,$tab,$output);
$tab = $DB->table('Links');
$tab->select_options('ORDER BY Title', 'LIMIT ' . $linksPP . ' OFFSET ' . $start);
$sth = $tab->select( { isValidated => 'Yes', isFeatured => 'Yes' } );
my $hits = $tab->hits;
while (my $rec = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('link2', $rec);
}
my $tags;
$tags->{'paging.url'} = $CFG->{db_cgi_url} . "/featured.cgi";
$tags->{'paging.num_hits'} = $hits;
$tags->{'paging.current_page'} = $pageNum;
print $IN->header();
print Links::SiteHTML::display('featured', $tags);
}
Code:
#!/usr/local/bin/perl
#================================
use strict;
use lib '/var/home/moen/wiredbiz.com/cgi-bin/links/admin';
use Links qw/$DB $IN $CFG/;
Links::init('/var/home/moen/wiredbiz.com/cgi-bin/links/admin');
use Links::SiteHTML;
local $SIG{__DIE__} = \&Links::fatal;
main();
sub main {
#---------------------------------------------------
#
my $pageNum = $IN->param('nh') || 1;
# number of links per page
my $linksPP = 10;
my $start = $linksPP*$pageNum - $linksPP;
my ($sth,$tab,$output);
$tab = $DB->table('Links');
$tab->select_options('ORDER BY Title', 'LIMIT ' . $linksPP . ' OFFSET ' . $start);
$sth = $tab->select( { isValidated => 'Yes', isFeatured => 'Yes' } );
my $hits = $tab->hits;
while (my $rec = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('link2', $rec);
}
my $tags;
$tags->{'paging.url'} = $CFG->{db_cgi_url} . "/featured.cgi";
$tags->{'paging.num_hits'} = $hits;
$tags->{'paging.current_page'} = $pageNum;
print $IN->header();
print Links::SiteHTML::display('featured', $tags);
}