Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

Ignore whitespace Rev 1249 → Rev 1300

/trunk/services/modules/0.1/bdtfx/CommunNomsTaxons.php
757,7 → 757,11
if (preg_match('/^([^_-]+)(?:_|-)([^_-]+)$/', $code, $match)) {
$code = $match[1].ucfirst($match[2]);
}
$requete = sprintf('SELECT * FROM %s WHERE id IN (SELECT id FROM %s WHERE code = "%s" AND classe_id = (SELECT id FROM %s WHERE code = "%s")) LIMIT 0, 100 -- %s:%s', Config::get('bdd_table_ontologies'), Config::get('bdd_table_ontologies'), $valeur, Config::get('bdd_table_ontologies'), $code, __FILE__, __LINE__);
$bdd = Config::get('bdd_table_ontologies');
$requete = sprintf(
'SELECT ba.* FROM %s ba JOIN %s bb ON (ba.id = bb.id AND bb.code = "%s") JOIN %s bc ON (bc.id= bb.classe_id AND bc.code = "%s") LIMIT 0, 100 -- %s:%s',
$bdd, $bdd, $valeur, $bdd, $code, __FILE__, __LINE__
);
$res = $this->getBdd()->recuperer($requete);
$nom_code = $valeur;
if (is_array($res)) {