[Koha-cvs] koha/C4 SearchMarc.pm [rel_2_2]

[Ryan Higgins]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_2_2
Changes by:	Ryan Higgins <rych>	07/01/29 03:45:37

Modified files:
	C4             : SearchMarc.pm 

Log message:
	mysql 5 syntax change

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/SearchMarc.pm?cvsroot=koha&only_with_tag=rel_2_2&r1=1.36.2.35&r2=1.36.2.36

Patches:
Index: SearchMarc.pm
===================================================================
RCS file: /sources/koha/koha/C4/Attic/SearchMarc.pm,v
retrieving revision 1.36.2.35
retrieving revision 1.36.2.36
diff -u -b -r1.36.2.35 -r1.36.2.36
--- SearchMarc.pm	3 Nov 2006 10:59:51 -0000	1.36.2.35
+++ SearchMarc.pm	29 Jan 2007 03:45:37 -0000	1.36.2.36
@@ -381,9 +381,9 @@
 	# HINT : biblionumber as bn is important. The hash is fills biblionumber with items.biblionumber.
 	# so if you dont' has an item, you get a not nice empty value.
 	$sth = $dbh->prepare("SELECT biblio.biblionumber as bn,biblioitems.*,biblio.*, marc_biblio.bibid,itemtypes.notforloan,itemtypes.description
-							FROM biblio, marc_biblio 
-							LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber
-							LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype
+							FROM  marc_biblio , biblio
+							LEFT JOIN biblioitems on ( biblio.biblionumber = biblioitems.biblionumber )
+							LEFT JOIN itemtypes on (itemtypes.itemtype=biblioitems.itemtype)
 							WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ?");
         my $sth_subtitle = $dbh->prepare("SELECT subtitle FROM bibliosubtitle WHERE biblionumber=?"); # Added BY JF for Subtitles
 	my @finalresult = ();