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)) { |