57,11 → 57,11 |
|
public function obtenirLiaisonsMotsClesOriginaux() { |
if ($this->mode == 'obs') { |
$requete = "SELECT comc.id_observation as id_element_lie, comc.id_mot_cle_obs as id_mot_cle, id_utilisateur as id_utilisateur ". |
$requete = "SELECT comc.id_observation AS id_element_lie, comc.id_mot_cle_obs AS id_mot_cle, id_utilisateur AS id_utilisateur ". |
"FROM cel_obs_mots_cles comc ". |
"INNER JOIN cel_obs o ON o.id_observation = comc.id_observation "; |
} else { |
$requete = "SELECT comc.id_image as id_element_lie, comc.id_mot_cle_image as id_mot_cle, o.ce_utilisateur as id_utilisateur ". |
$requete = "SELECT comc.id_image AS id_element_lie, comc.id_mot_cle_image AS id_mot_cle, o.ce_utilisateur AS id_utilisateur ". |
"FROM cel_images_mots_cles comc ". |
"INNER JOIN cel_images o ON o.id_image = comc.id_image "; |
} |