Subversion Repositories eFlore/Applications.cel

Rev

Rev 520 | Rev 550 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 520 Rev 533
Line 250... Line 250...
250 
		// Récupération du filtre where pour les mots clés "projet"
 250 
		// Récupération du filtre where pour les mots clés "projet"
251 
		if (isset($projet)) {
 251 
		if (isset($projet)) {
252 
			$projet_sql = $this->getSqlWhereProjet($projet);
 252 
			$projet_sql = $this->getSqlWhereProjet($projet);
253 
		}
 253 
		}
Line 254... Line 254...
254 
 
 254 
 
255 
		$requete = 	'SELECT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '.
 255 
		$requete = 	'SELECT DISTINCT nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille '.
256 
					'FROM cel_inventory AS i '.
 256 
					'FROM cel_inventory AS i '.
257 
					'	LEFT JOIN locations AS l '.
 257 
					'	LEFT JOIN locations AS l '.
258 
					"		ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ".
 258 
					"		ON (l.name = i.location AND l.code = TRIM(LEADING '0' FROM i.id_location)) ".
259 
					"WHERE transmission = '1' ".
 259 
					"WHERE transmission = '1' ".