Subversion Repositories eFlore/Archives.herbiers

Rev

Rev 22 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 22 Rev 28
Line 144... Line 144...
144 
						'	OR 	HC.COLLECTEURS LIKE "%'.$RECHERCHE.'%" '.
 144 
						'	OR 	HC.COLLECTEURS LIKE "%'.$RECHERCHE.'%" '.
145 
						'	OR 	HC.STRENGTH LIKE "%'.$RECHERCHE.'%" '.
 145 
						'	OR 	HC.STRENGTH LIKE "%'.$RECHERCHE.'%" '.
146 
						'	OR 	HC.NOM_COLLECTION LIKE "%'.$RECHERCHE.'%" '.
146 
						'	OR 	HC.NOM_COLLECTION LIKE "%'.$RECHERCHE.'%" '.
147 
						'	OR 	HC.COLLECTION_CODE LIKE "%'.$RECHERCHE.'%" '.
 147 
						'	OR 	HC.COLLECTION_CODE LIKE "%'.$RECHERCHE.'%" '.
148 
						'	OR 	HO.INSTITUTION_NAME LIKE "%'.$RECHERCHE.'%" '.
 148 
						'	OR 	HO.INSTITUTION_NAME LIKE "%'.$RECHERCHE.'%" '.
149 
						'	OR 	HO.ADRESS_TEXT LIKE "%'.$RECHERCHE.'%" '.
 149 
						'	OR 	HO.ADRESS_LINE LIKE "%'.$RECHERCHE.'%" '.
150 
						'	OR 	HO.TOWN LIKE "%'.$RECHERCHE.'%" '.
 150 
						'	OR 	HO.TOWN LIKE "%'.$RECHERCHE.'%" '.
151 
						'	OR 	HO.REGION LIKE "%'.$RECHERCHE.'%" '.
 151 
						'	OR 	HO.REGION LIKE "%'.$RECHERCHE.'%" '.
152 
						'	OR 	HO.INDEX_HERB LIKE "%'.$RECHERCHE.'%" '.
 152 
						'	OR 	HO.INDEX_HERB LIKE "%'.$RECHERCHE.'%" '.
153 
						') '.
 153 
						') '.
154 
                        'ORDER BY TOWN';
 154 
                        'ORDER BY TOWN';