Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 329 Rev 357
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_01') {
440
	public function obtenirSynonymesParNumNomAvecInfosFlore($num_nom, $version='1_02') {
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 '.
444
						'flore_fe_num, flore_fe_rem '.
444
						'flore_fe_num, flore_fe_rem '.
445
						'flore_coste_num, flore_coste_rem '. 	
445
						'flore_coste_num, flore_coste_rem '. 	
Line 446... Line 446...
446
						'flore_fh_num, flore_fh_rem '.	
446
						'flore_fh_num, flore_fh_rem '.	
447
						'flore_fournier_num, flore_fournier_rem';
447
						'flore_fournier_num, flore_fournier_rem';
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 '.$this->table.' '.
451
						'WHERE num_nom_retenu = '.
451
						'WHERE num_nom_retenu = '.
Line 452... Line 452...
452
						'('.
452
						'('.
453
						'SELECT num_nom_retenu FROM bdtfx_v'.$version.' WHERE num_nom = "'.$num_nom.'"'.
453
						'SELECT num_nom_retenu FROM '.$this->table.' WHERE num_nom = "'.$num_nom.'"'.