I have a global to search Links table and it works fine.
sub {
my $tags = shift;
my $query = $tags->{query};
my $search_db = $DB->table('Links');
$search_db->select_options ("ORDER BY $CFG->{build_sort_order_category}");
my $sth = $search_db->query_sth ( {
isValidated => 'Yes',
query => $query,
ma => 1,
nh => 1,
mh => 10
} );
my @output;
while (my $link = $sth->fetchrow_hashref) {
push (@output, $link);
}
return { query_search_results_loop => \@output };
}
On site i use:
<%name_of_the_global%>
<%loop query_search_results_loop%>
<%include link.html%>
<%endloop%>
My problem is:
I have limited the number of results to 10 (with mh => 10)
but I would like to know the number of available results if the number exceeds 10.
Thanks in advance!
sub {
my $tags = shift;
my $query = $tags->{query};
my $search_db = $DB->table('Links');
$search_db->select_options ("ORDER BY $CFG->{build_sort_order_category}");
my $sth = $search_db->query_sth ( {
isValidated => 'Yes',
query => $query,
ma => 1,
nh => 1,
mh => 10
} );
my @output;
while (my $link = $sth->fetchrow_hashref) {
push (@output, $link);
}
return { query_search_results_loop => \@output };
}
On site i use:
<%name_of_the_global%>
<%loop query_search_results_loop%>
<%include link.html%>
<%endloop%>
My problem is:
I have limited the number of results to 10 (with mh => 10)
but I would like to know the number of available results if the number exceeds 10.
Thanks in advance!