|
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 |
- |
|
|