As long as your "isFeatured" column has the same properties (enum, yes, no etc) as isNew, isPopular, and isChanged... you can call it the same way <%if isFeatured%>.... you don't need the eq 'yes' part.
Okay. Your main function should now look something like this:
sub main {
#---------------------------------------------------
#
my $pageNum = $IN->param('page') ||= 1;
# number of links per page
my $linksPP = 10;
my $end = $linksPP*$pageNum;
my $start = $end - $linksPP;
my ($sth,$tab,$output);
$tab = $DB->table('Links');
$tab->select_options('LIMIT $start OFFSET $end');
$sth = $tab->select( { isValidated => 'Yes', isFeatured => 'Yes' } );
while (my $rec = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('link2', $rec);
}
print $IN->header();
print Links::SiteHTML::display('featured', { output => $output});
}
I may have mistyped something on the pages part, but it should work.
(**crossing fingers...**)
- Jonathan
Okay. Your main function should now look something like this:
Quote:
sub main {
#---------------------------------------------------
#
my $pageNum = $IN->param('page') ||= 1;
# number of links per page
my $linksPP = 10;
my $end = $linksPP*$pageNum;
my $start = $end - $linksPP;
my ($sth,$tab,$output);
$tab = $DB->table('Links');
$tab->select_options('LIMIT $start OFFSET $end');
$sth = $tab->select( { isValidated => 'Yes', isFeatured => 'Yes' } );
while (my $rec = $sth->fetchrow_hashref) {
$output .= Links::SiteHTML::display('link2', $rec);
}
print $IN->header();
print Links::SiteHTML::display('featured', { output => $output});
}
I may have mistyped something on the pages part, but it should work.
(**crossing fingers...**)
- Jonathan