Lines 82-88
if($advanced_search_types eq 'ccode'){
Link Here
|
82 |
GROUP BY biblio.biblionumber |
82 |
GROUP BY biblio.biblionumber |
83 |
HAVING tot >0 |
83 |
HAVING tot >0 |
84 |
ORDER BY tot DESC |
84 |
ORDER BY tot DESC |
85 |
LIMIT $limit |
85 |
LIMIT ? |
86 |
"; |
86 |
"; |
87 |
$template->param(ccodesearch => 1); |
87 |
$template->param(ccodesearch => 1); |
88 |
}else{ |
88 |
}else{ |
Lines 107-119
if($advanced_search_types eq 'ccode'){
Link Here
|
107 |
GROUP BY biblio.biblionumber |
107 |
GROUP BY biblio.biblionumber |
108 |
HAVING tot >0 |
108 |
HAVING tot >0 |
109 |
ORDER BY tot DESC |
109 |
ORDER BY tot DESC |
110 |
LIMIT $limit |
110 |
LIMIT ? |
111 |
"; |
111 |
"; |
112 |
$template->param(itemtypesearch => 1); |
112 |
$template->param(itemtypesearch => 1); |
113 |
} |
113 |
} |
114 |
|
114 |
|
115 |
my $sth = $dbh->prepare($query); |
115 |
my $sth = $dbh->prepare($query); |
116 |
$sth->execute(); |
116 |
$sth->execute($limit); |
117 |
my @results; |
117 |
my @results; |
118 |
while (my $line= $sth->fetchrow_hashref) { |
118 |
while (my $line= $sth->fetchrow_hashref) { |
119 |
push @results, $line; |
119 |
push @results, $line; |
120 |
- |
|
|