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!

Anybody?

Hi,

Maybe something like this?


Also, any reason your doing it through query_sth and not select() .. i.e $DB->table('Links')->select( GT::SQL::Condition->new(....) )

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