WebSVN – eFlore/Applications.cel – Diff – /trunk/jrest/bibliotheque/RechercheImage.php

     public function formaterPourEnvoiCel(&$tableau_images) {
     	foreach($tableau_images as &$image) {
     		$ids_mots_cles = $this->getIdsMotsClesImage($image['id_image']);
     		$mots_cles_chaine = '';
     		foreach($ids_mots_cles as $id_mot_cle) {
-    			$mots_cles_chaine .= $id_mot_cle['id_mot_cle_image'].',';
+    			$mots_cles_chaine .= $id_mot_cle['id_mot_cle'].',';
+    		}
     		$mots_cles_chaine = rtrim($mots_cles_chaine,',');
     		$image['mots_cles'] = $mots_cles_chaine;
+    	}
 	    return $retour;
+    }
     private function getIdsMotsClesImage($id_image) {
-    	$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_image '.
+    	$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle '.
-    									   'FROM cel_images_mots_cles '.
+    									   'FROM cel_mots_cles_images_liaison '.
-    									   'WHERE id_image = '.$id_image;
+    									   'WHERE id_element_lie = '.$id_image;

Subversion Repositories eFlore/Applications.cel