Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1092 Rev 1097
Line 143... Line 143...
143 
		$emplacements = null;
 143 
		$emplacements = null;
144 
		$coordonnees_nulles = "coord_x = '000null' OR coord_x = '' ".
 144 
		$coordonnees_nulles = "coord_x = '000null' OR coord_x = '' ".
145 
								" OR coord_y = '000null' OR coord_y = ''";
 145 
								" OR coord_y = '000null' OR coord_y = ''";
146 
		$coordonnees_non_nulles = "coord_x != '000null' AND coord_x != '' ".
 146 
		$coordonnees_non_nulles = "coord_x != '000null' AND coord_x != '' ".
147 
								" AND coord_y != '000null' AND coord_y != ''";
147 
								" AND coord_y != '000null' AND coord_y != ''";
148
- 
 
149 
		$coordonnees_non_nulles_pas_sensible = "(".$coordonnees_non_nulles." AND mots_cles_texte NOT LIKE '%sensible%')";
 148 
		$coordonnees_non_nulles_pas_sensible = "(".$coordonnees_non_nulles." AND mots_cles_texte NOT LIKE '%sensible%')";
Line 150... Line 149...
150
149
151 
		$requete =  'SELECT DISTINCT *, location AS nom, '.
 150 
		$requete =  'SELECT DISTINCT *, location AS nom, '.
152 
							"IF (".$coordonnees_non_nulles_pas_sensible.", ".
 151 
							"IF (".$coordonnees_non_nulles_pas_sensible.", ".