Récupérer les valeurs liste selection multipl

« les valeurs liste selection multiple »

<select name="nomListe[]" multiple="multiple">

	// All users ordered by user_name column
	$sql->db_Select("portofolio_references", "*", "ORDER BY portofolio_ref_id ASC LIMIT 0,4", "no-where");
	while($row = $sql->db_Fetch()) {
		$id_fiche = $row[0];
		$image_grosse_aff = "<img src='".e_PLUGIN."portofolio/upload/".$row[1]."' alt='' style='width:350px;height:300px;' />";
		$image_petite1_aff = "<img src='".e_PLUGIN."portofolio/upload/".$row[2]."' alt='' style='width:185px;height:149px;border-left:1px solid #fff;' />";
		$image_petite2_aff = "<img src='".e_PLUGIN."portofolio/upload/".$row[3]."' alt='' style='width:185px;height:150px;border-left:1px solid #fff;border-top:1px solid #fff;' />";
		$titre_aff = $row[4];
		$contenu_aff = $row[5]; 
		$lien_site_aff = "<a href='http://".$row[6]."' title='Vistez le site' target='_blank'><img src='".e_PLUGIN."portofolio/images/visitez_le_site.png' alt='Lien fiche' /></a>";
		$tech_aff = $row[7];
				
		// je ramene les id des compétences du membre
		$query_l_competences = "SELECT portofolio_references_portofolio_ref_id, portofolio_competences_portofolio_comp_id 
									FROM ".MPREFIX."portofolio_references_has_portofolio_competences 
										WHERE portofolio_references_portofolio_ref_id='$id_fiche'";								
		$result_l_competences = mysql_query($query_l_competences) OR DIE (mysql_error());

		while($row = mysql_fetch_row($result_l_competences)){
			$id_competences_collaborateur = $row[0];
			$id_competences_liste = $row[1];	
			
			$comp_list .= $id_competences_liste.",";
		}
		
		// on place le resultat dans une variable et on enleve le dernier caractere
		$comp_list = rtrim($comp_list,",");

		// je ramene les noms des competences du membre
		$query_competences = "SELECT portofolio_comp_id, portofolio_comp_nom, portofolio_comp_libelle 
								  FROM ".MPREFIX."portofolio_competences 
									  WHERE portofolio_comp_id IN ($comp_list)";
		$result_competences = mysql_query($query_competences) OR DIE (mysql_error());

		while($row = mysql_fetch_row($result_competences)){
			$id_competences = $row[0];
			$nom_competences = $row[1];
			
			$noms_comp .= "<li>$nom_competences</li>";
		}
		
		// $Description = $tp->toFORM($tp->html_truncate($download_description, 230, "..."));
		
		$contenu .= "
			<div class='panel' title='Fiche $id_fiche'>
				<div class='wrapper'>
					<div style='float:left;margin:0;padding:0 0px 0 0;width:350px;'>
						$image_grosse_aff
					</div>
					<div style='float:left;margin:0;padding:0;width:185px;'>
						$image_petite1_aff
						$image_petite2_aff
					</div>
					<div style='float:left;width:350px;'>
						<h3>$titre_aff</h3>
						<p>
							$contenu_aff
							$lien_site_aff<br />$comp_list
						<p>
					</div>
					<div style='float:left;width:185px;'>
						<h3>Comp&eacute;tences utiliser:</h3>
						<div class='checkList'>
						<ul class='check'>
							$noms_comp
						</ul>
					</div>
				</div>
				</div>
			</div>	
		";
	}