Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Next link Bug

Quote Reply
Next link Bug
For all of you using DBmanSQL - there is a bug...If your totalhits on a search is equal to a multiple of your maxhits then your "next" link will not appear on the penultimate page. Example : search results = 20 and maxhits = 5 - on page 3 numerical link for page 4 appears but not the "next page" link. Fix is as follows :

Find the following line in sub query :

Code:
$db_next_hits .= qq~<a href="$db_script_url?$next_url&nh=$next_hit">[>>]</a> ~ unless ($next_hit == $i);
and replace with :

Code:
if ($numhits%$maxhits == 0 && $nh != $next_hit) {
$db_next_hits .= qq~<a href="$db_script_url?$next_url&nh=$next_hit">[>>]</a> ~ unless ($next_hit == $i + 1);
}
else{
$db_next_hits .= qq~<a href="$db_script_url?$next_url&nh=$next_hit">[>>]</a> ~ unless ($next_hit == $i);
}
easy does it