Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 519 Rev 520
Line 222... Line 222...
222
					(($type == 'UTM') ? "	AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : '').
222
					(($type == 'UTM') ? "	AND (sector = '$secteur' AND x_utm = '$x_utm' AND y_utm = '$y_utm' ) " : '').
223
					(($type == 'LngLat') ? "	AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : '').
223
					(($type == 'LngLat') ? "	AND (coord_x = '$coord_x' AND coord_y = '$coord_y' ) " : '').
224
					(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
224
					(isset($utilisateur) ? " AND identifiant = '$utilisateur' " : '').
225
					(isset($dept) ? " AND l.insee_code LIKE '$dept%' " : '').
225
					(isset($dept) ? " AND l.insee_code LIKE '$dept%' " : '').
226
                    (isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
226
                    (isset($num_taxon) ? " AND num_taxon = '$num_taxon' " : '' ).
227
                    ((isset($projet) && $projet_sql != '') ? " AND ($projet_sql) " : '' );
227
                    ((isset($projet) && $projet_sql != '') ? " AND ($projet_sql) " : '' ).
-
 
228
                    'ORDER BY nom_sel ASC ';
-
 
229
                    
228
		//$this->debug[] = $requete;
230
		//$this->debug[] = $requete;
Line 229... Line 231...
229
 
231
 
Line 230... Line 232...
230
		$resultats = $this->executerRequete($requete);
232
		$resultats = $this->executerRequete($requete);