Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 190 Rev 194
Line 39... Line 39...
39 
		$detailsId = $this->bdd->proteger($detailsId);
 39 
		$detailsId = $this->bdd->proteger($detailsId);
40 
		$requete =
 40 
		$requete =
41 
			'SELECT ns.*,  '.
 41 
			'SELECT ns.*,  '.
42 
			'	nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
 42 
			'	nr.nom_sci AS nr_nom_sci, nb.nom_sci AS nb_nom_sci '.
43 
			'FROM fournier_v1_00 AS ns '.
 43 
			'FROM fournier_v1_00 AS ns '.
44 
			'	LEFT JOIN bdtfx_v1_01 AS nr ON (ns.num_nom_retenu = nr.num_nom) '.
 44 
			'	LEFT JOIN fournier_v1_00 AS nr ON (ns.num_nom_retenu = nr.num_nom) '.
45 
			'	LEFT JOIN bdtfx_v1_01 AS nb ON (ns.basionyme = nb.num_nom) '.
 45 
			'	LEFT JOIN fournier_v1_00 AS nb ON (ns.basionyme = nb.num_nom) '.
46 
			"WHERE ns.num_nom = $detailsId ";
 46 
			"WHERE ns.num_nom = $detailsId ";
47 
		$resultats = $this->bdd->recuperer($requete);
 47 
		$resultats = $this->bdd->recuperer($requete);
48 
		return $resultats;
 48 
		return $resultats;
49 
	}
 49 
	}