From bb7b30868286db6e6253cc12bfec5d8853701fa4 Mon Sep 17 00:00:00 2001 From: rangi Date: Tue, 27 Nov 2001 02:01:39 +0000 Subject: [PATCH] Fixing error in keyword search (fixing my mistake from yesterday) --- C4/Search.pm | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/C4/Search.pm b/C4/Search.pm index 4065088e72..0cc4c9c4aa 100755 --- a/C4/Search.pm +++ b/C4/Search.pm @@ -301,14 +301,14 @@ sub KeywordSearch { or seriestitle like '% new zealand')" } $query=$query."))"; - if ($search->{'class'} ne ''){ + if ($search->{'class'} ne ''){ my @temp=split(/\|/,$search->{'class'}); my $count=@temp; $query.= "and ( itemtype='$temp[0]'"; for (my $i=1;$i<$count;$i++){ $query.=" or itemtype='$temp[$i]'"; - } - $query.=")"; + } + $query.=")"; } $query.="group by biblio.biblionumber order by author,title"; # print $query; @@ -334,8 +334,8 @@ sub KeywordSearch { $sth->execute; while (my $data=$sth->fetchrow_hashref){ $query="Select * from biblio,biblioitems where - biblio.biblionumber=$data->{'biblionumber'} and biblio.biblionumber=biblioitems.biblionumber - group by biblio.biblionumber"; + biblio.biblionumber=$data->{'biblionumber'} and + biblio.biblionumber=biblioitems.biblionumber "; if ($search->{'class'} ne ''){ my @temp=split(/\|/,$search->{'class'}); my $count=@temp; -- 2.39.2