Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 306 Rev 329
Line 435... Line 435...
435
			$retour_id_hom = null; 
435
			$retour_id_hom = null; 
436
		}
436
		}
437
		return $retour_id_hom;
437
		return $retour_id_hom;
438
	}
438
	}
Line 439... Line 439...
439
	
439
	
Line 440... Line 440...
440
	public function obtenirSynonymesParNumNomAvecInfosFlore($num_nom, $version='1_02') {
440
	public function obtenirSynonymesParNumNomAvecInfosFlore($num_nom, $version='1_01') {
441
		
441
		
442
		$champs_flore = 'flore_bonnier_num, flore_bonnier_rem,'. 
442
		$champs_flore = 'flore_bonnier_num, flore_bonnier_rem,'. 
443
						'flore_cnrs_num, flore_cnrs_rem '.
443
						'flore_cnrs_num, flore_cnrs_rem '.
Line 448... Line 448...
448
		
448
		
449
		$requete = 'SELECT num_nom, nom_sci, '.$champs_flore.' '.
449
		$requete = 'SELECT num_nom, nom_sci, '.$champs_flore.' '.
450
						'FROM bdtfx_v'.$version.' '.
450
						'FROM bdtfx_v'.$version.' '.
451
						'WHERE num_nom_retenu = '.
451
						'WHERE num_nom_retenu = '.
452
						'('.
452
						'('.
453
						'SELECT num_nom_retenu FROM bdtfx_v1_02 WHERE num_nom = "'.$num_nom.'"'.
453
						'SELECT num_nom_retenu FROM bdtfx_v'.$version.' WHERE num_nom = "'.$num_nom.'"'.
Line 454... Line 454...
454
						')';
454
						')';
455
		
455