113,7 → 113,7 |
|
$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_obs '. |
'FROM cel_obs_mots_cles '. |
'WHERE id_observation = '.$id_observation; |
'WHERE id_observation = '.$id_observation; |
|
return $this->requeter($requete_selection_mots_cles); |
} |
173,7 → 173,7 |
case 'id_mots_cles': |
$liste_mc = '"'.str_replace(';','","',$valeur).'"'; |
$sous_requete .= '' ; |
$sous_requete .= 'id_observation IN (SELECT id_observation FROM cel_obs_mots_cles WHERE id_mot_cle_utilisateur IN ('.$liste_mc.'))'; |
$sous_requete .= 'id_observation IN (SELECT id_observation FROM cel_obs_mots_cles WHERE id_mot_cle_obs IN ('.$liste_mc.'))'; |
$sous_requete .= ' AND ' ; |
break; |
|