create_concept_string(); //bloc recuperation infos cluster $resultat=mysql_query("SELECT label_1,label_2,periode,concept FROM cluster WHERE id_cluster=".$id_cluster." AND periode=\"".derange_periode($periode)."\" ORDER by periode,concept") or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) $cluster[]=$ligne; //bloc recuperation infos termes $resultat=mysql_query("select id,forme_principale FROM concepts ORDER by forme_principale") or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) $liste_termes[$ligne['id']] = $ligne['forme_principale']; //bloc recuperation infos phylogenie $sql="SELECT id_cluster_2,periode_2 FROM phylo WHERE id_cluster_1=\"".$id_cluster."\" AND periode_1=\"".derange_periode($periode)."\""; $resultat=mysql_query($sql) or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) {$periode_avant_temp = $ligne['periode_2']; if (intval($periode_avant_temp)< intval($periode)){$predecesseur[] = $ligne['id_cluster_2']; $periode_avant =$periode_avant_temp; } } $sql="SELECT id_cluster_1,periode_1 FROM phylo WHERE id_cluster_2=\"".$id_cluster."\" AND periode_2=\"".derange_periode($periode)."\""; $resultat=mysql_query($sql) or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) {$periode_apres_temp = $ligne['periode_1'];if (intval($periode_apres_temp)> intval($periode)) {$successeur[] = $ligne['id_cluster_1']; $periode_apres = $ligne['periode_1']; }} //on ferme l'acces à la base de donnees mysql_close(); echo '<p><table width=100% class=tableitems>'; echo '<tr valign=top><td width=2.5%></td><td><h2 class=subtitle>champ thématique "<i>'.$dico_termes[$cluster[0]["label_1"]].'</i><i style="font-weight:normal;"> - '.$dico_termes[$cluster[0]["label_2"]].'"</i> <i style="font-size:x-small; font-weight:normal;">(#'.$id_cluster.')</i></h2></td><td width=2.5%></td></tr>'; echo '<table width=100%>'; echo '<tr valign=top><td width=2.5%></td><td><div class=subbanner>période '.get_string_periode($periode).'</div></td><td width=2.5%></td></tr>'; echo '</table>';
} //******************************************* //bloc récupération des sources //******************************************* //$resultat=mysql_query("select id,auteurs FROM auteurs ORDER by auteurs") or die ("Reque non executée."); $resultat = mysql_query("SELECT auteurs.id, auteurs\nFROM socsem, auteurs\nWHERE auteurs.id = socsem.auteur\nGROUP BY socsem.auteur ORDER by auteurs\n") or die("Requête non executée sur socsem."); // $resultat=mysql_query("SELECT id, auteurs // FROM auteurs ORDER by auteurs // ") or die ("Requête non executée sur socsem."); while ($ligne = mysql_fetch_array($resultat)) { $nom_auteurs[] = $ligne["auteurs"]; $id_auteurs[] = $ligne["id"]; $dico_auteurs[$ligne["id"]] = $ligne["auteurs"]; } $id_auteurs_reduit = array(); $sql = "select id_auteur FROM biparti WHERE periode ='" . derange_periode($my_period) . "' GROUP by id_auteur "; $resultat = mysql_query($sql) or die("Reqe non executée."); while ($ligne = mysql_fetch_array($resultat)) { $champ_aut_id = $ligne["id_auteur"]; if ($champ_aut_id[0] = '[') { $champ_aut_id = str_replace('[', '', $champ_aut_id); $champ_aut_id = str_replace(']', '', $champ_aut_id); $champ_aut_id = explode(', ', $champ_aut_id); for ($i = 0; $i < count($champ_aut_id); $i++) { $id_auteurs_reduit[] = $champ_aut_id[$i]; $dico_auteurs_reduit[$champ_aut_id[$i]] = $dico_auteurs[$champ_aut_id[$i]]; } } else { $id_auteurs_reduit[] = $champ_aut_id; $dico_auteurs_reduit[$champ_aut_id] = $dico_auteurs[$champ_aut_id]; }
echo $orphan_filter; foreach ($periodes as $per ) { $clusters_pertinents=array(); if ($list_of_periods[count($list_of_periods)-1]==$per) {$clause_fils_pere = '';} else {$clause_fils_pere = ' AND nb_sons+nb_fathers>='.$orphan_filter;} $quer="select id_cluster FROM cluster WHERE periode ='".derange_periode($per)."'".$clause_fils_pere." GROUP by id_cluster ORDER by id_cluster"; echo "<br>"; echo $quer; $resultat=mysql_query($quer) or die ("<b>Requête non exécutée</b>."); while ($ligne=mysql_fetch_array($resultat)){ $clusters_pertinents[] = $ligne['id_cluster'];} echo '<br> clusters pertinents:<br>'; print_r($clusters_pertinents); echo '<br>'; $carte_per =$mapgexf.$per."_gs.gexf"; // echo '<br>'; echo '<br>'; echo $carte_per; echo '<br>';
echo '<input type="hidden" value="'.$label2.'" name="label2">'; echo '<input type="submit" value="Changer">'; echo '</form>'; echo "</tr></table>"; echo '<td width=2.5%></td></tr></table>'; echo "<p>"; //AFFICHAGE CONTENU DES CLUSTERS echo "<table width=100% class=tableitems><tr valign=top><td width=2.5%></td><td width=95%>"; $my_clusters_all=$clusters[derange_periode($my_period)]; foreach ($my_clusters_all as $kmy=>$my) { $my_clusters[$kmy]=$my["ids"]; $my_letters[$kmy]=$my["info"]; } ksort($my_clusters); echo '<table width=100% class=commentitems><tr valign=top><td width=100% style="font-style:italic;">'; echo 'Il existe en effet plusieurs champs thématiques désignés par cette paire d\'étiquettes "terme générique - </b>terme spécifique<b>"</b><br>Voici la liste des termes communs à tous ces champs thématiques:</td></tr></table>'; //echo 'IL EXISTE EN EFFET PLUSIEURS CHAMPS THÉMATIQUES DÉSIGNÉS PAR CETTE PAIRE D\'ÉTIQUETTES "<b>TERME GÉNÉRIQUE - </b>TERME SPÉCIFIQUE"</b><br>VOICI LA LISTE DES TERMES COMMUNS À TOUS CES CHAMPS THÉMATIQUES:</td></tr></table>'; echo '<table width=100% class=tableitems><tr valign=top><td width=100% style="font-size:10pt; font-style:italic; font-variant:small-caps;"><b>'; echo 'termes communs aux champs thématiques étiquetés par "'.$dico_termes[$label1].' - </b>'.$dico_termes[$label2].'<b>"</b></td></tr></table>'; //echo "<h2 class=inverted>\"</h2>";
<? include("login_check.php"); include("include/header.php"); //connexion a la base de donnees include("banner.php"); include("parametre.php"); include("library/fonctions_php.php"); if( isset( $_GET['id_label'] ) ) $id_label = ( $_GET['id_label'] );//id du label du noeud if( isset( $_GET['id_label1'] ) ) $id_label1 = ( $_GET['id_label1'] );//id du label du noeud if( isset( $_GET['id_label2'] ) ) $id_label2 = ( $_GET['id_label2'] );//id du label du noeud if( isset( $_GET['type'] ) ) $type = ( $_GET['type'] );//type de labellisation generique/specifique if( isset( $_GET['periode'] ) ) $my_period =derange_periode($_GET['periode']);// periode else $my_period = '-1'; connexion_base($server,$user,$password,$database); //bloc recuperation infos du noeud de la carte: //un noeud= un ensemble de clusters qui partagent le même label. $resultat=mysql_query("select id,forme_principale FROM concepts ORDER by forme_principale") or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) $liste_termes[$ligne['id']] = $ligne['forme_principale']; create_concept_string(); if ($type=="s") { $sql ="select id_cluster FROM cluster WHERE periode = \"".$my_period."\" and label_2 = \"".$id_label."\" GROUP by id_cluster";//on s'attache à extraire l'ensemble des clusters associés au label specifique donné } elseif ($type=="g")
echo "</div>"; } else { echo '<table class=tableitems width=100% rules=groups>'; echo '<tr style="font-variant:small-caps; font-size:small; margin-top:2px; margin-bottom:-2px;">'; echo '<td>nom du champ auquel participe la source</td>'; echo '<td width=45pt></td>'; echo '<td>↑/↓</td>'; echo '<td width=5%></td>'; echo '<td>numéros des billets'; //echo '<br>(voir aussi l\'onglet "billets")'; echo '</td>'; echo '</tr>'; foreach ($periode_a_faire as $pp) { $pp=derange_periode($pp); $c=$clusters[$pp]; $cstr=array(); if (count($c)>0){ //y-a-t-il au moins des clusters pour la periode? if ($my_period==-1) echo "<tr><td class=small>période ".get_string_periode(arrange_periode($pp))."</td></tr>"; foreach ($c['clusters'] as $cp) { $resultat=mysql_query("SELECT label_1,label_2,lettre,nb_sons,nb_fathers FROM cluster WHERE id_cluster=".$cp['id']." AND periode=\"".$cp['periode']."\" ORDER by periode,concept") or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) $clu_tmp[]=$ligne; $clu_tmp=end($clu_tmp); $label1=$clu_tmp['label_1']; $label2=$clu_tmp['label_2']; $lettre=$clu_tmp['lettre']; $nbsons=$clu_tmp['nb_sons']; $nbfathers=$clu_tmp['nb_fathers']; $hrefh='href=cluster.php?id_cluster='.$cp['id'].'&periode='.arrange_periode($cp['periode']).'>';
if (in_array($identifiant_unique,$clusterdeja)) {echo '<br>deja vu<br>';} else { $list_of_concepts=array(); $periode=$lignede['periode']; echo $id_cluster."<br>"; $periode = str_replace(' ','-',$periode); echo $periode."<br>"; $list_of_concepts=array(); $sql="SELECT concept FROM cluster WHERE id_cluster=".$id_cluster." AND periode=\"".derange_periode($periode)."\""; //echo $sql; $resultat=mysql_query($sql) or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) $list_of_concepts[]=$ligne['concept']; //// BLOC COMPOSITION $liste_of_posts = scan_billet($list_of_concepts,$periode); $temps_fin3 = microtime_float();
function display_cluster_title ($s, $direction) { global $dico_termes,$mainloc,$arraykey,$last_display_periode,$jscriptmp,$my_period,$nav; $label1=$s['label1']; $label2=$s['label2']; $lettre=$s['lettre']; $shref='cluster.php?id_cluster='.$s['id']."&periode=".arrange_periode($s['periode']).'&nav='.$nav; $speriode=get_short_string_periode(arrange_periode($s['periode']),0,1); $stitle='"<b>'.remove_popo($dico_termes[$label1]).'</b> - '.remove_popo($dico_termes[$label2]).'"'; // $periodchange indique si on a un changement de période par rapport au dernier champ thématique affiché $periodchange=($last_display_periode!=$s['periode']); $ecart=floor(abs(compute_periode(derange_periode($my_period))-compute_periode($s['periode']))/7001000); //if ($periodchange && $last_display_periode!="") // echo '<tr style="background:white;"><td></td><td></td><td></td><td><hr class="dashed"></td></tr>'; //else { //if (!$periodchange) echo '<tr style="height:4px;font-size:0pt;'.($ecart>0?' background:white;':'').'"><td> </td><td></td><td></td><td></td></tr>'; } echo '<tr width=100% valign=top'.($ecart>0?' style="background:white;"':'').'>'; echo '<td class=commentitems style="font-size:xx-small;">'; if ($ecart>0 && $periodchange) echo ("<b>...</b> "); echo '</td>'; echo '<td class=commentitems style="font-size:xx-small;">'; if ($last_display_periode!=$s['periode']) echo $speriode." "; if ($ecart>0 && $periodchange) echo "<br/><b> [".($direction=="succ"?"+":"-").($ecart+1)." sem.] </b>"; echo '</td>'; $sbox=selective_column_tt($arraykey,$s['termes'],$s['plus'],$s['minus']); $sid=$s['id']."_".str_replace(" ","_",$s['periode']); if ($direction=="succ") { if (intval($s['fils'])>0) $sarrow='↓ '; } else { if (intval($s['pere'])>0) $sarrow='↑ '; } echo '<td>'; $jscriptmp.=display_helper('(période '.get_string_periode(arrange_periode($s['periode'])).')','<div style="font-variant:small-caps;"><a href='.$shref.'>'.$sarrow.$stitle.'</a></div><br>'.$sbox,$sid,"magnify-wide.png","resizable: true"); echo '</td>'; echo ' <td class=tableitems style="font-variant:small-caps; size:small; font-style:italic;">'; echo ' <span onMouseOver="ShowContent(\'box'.$sid.'\'); ShowContent(\'title'.$sid.'\'); HideContent(\'mainbox\'); HideContent(\'maintitle\');" onMouseOut="HideContent(\'box'.$sid.'\'); HideContent(\'title'.$sid.'\'); ShowContent(\'mainbox\'); ShowContent(\'maintitle\');">'; echo '<a id="'.$sid.'" href="'.$shref.'">'; echo '<span style="font-style:normal;">'.$sarrow.'</span>'.$stitle; if ($lettre!="") echo ' ('.$lettre.')'; echo '</a>'; echo '</span>'; //echo '<a id="'.$sid.'" class="questionMark jTip jTip_element_'.$sid.'S jTip_width_300" name="Détails" href="'.$shref.'">'; //echo '<span id="'.$sid.'S" class="JT_hidden">'; //echo $sbox; //echo '</span>'; echo '</td>'; echo '</tr>'; echo '<tr style="height:4px;font-size:0pt;'.($ecart>0?' background:white;':'').'"><td> </td><td></td><td></td><td></td></tr>'; echo '</td>'; $last_display_periode=$s['periode']; }
if (intval($fils[$i])>0) $arrows=$arrows.'↓'; if (!array_key_exists($titre,$groupes_clusters)) $groupes_clusters[$titre]=array("titre"=>$titre,"id"=>$id,"homos"=>array(),"label"=>$liste_termes_brute_id[$i],"href"=>""); $groupes_clusters[$titre]["homos"][]=array("id"=>$id,"arrows"=>$arrows); } uksort($groupes_clusters,"strcasecmpcam"); foreach ($groupes_clusters as $key => $value) { if (count($value["homos"])>1) { $tmp=""; for ($i=0;$i<count($value["homos"]);$i++){ $h=$value["homos"][$i]; $tmp.='<a class="dead" href="cluster.php?id_cluster='.$h["id"].'&periode='.$my_period.'">'.chr($i+65).$h["arrows"].'</a>'; $letter = chr($i+65); $sql_update = "UPDATE cluster SET lettre ='".$letter."' where id_cluster=".$h["id"]." AND periode='".derange_periode($my_period)."'"; echo $sql_update; mysql_query($sql_update); if ($i!=count($value["homos"])-1) $tmp.=', '; } $groupes_clusters[$key]["href"]='<a href="meta12.php?label1='.$value["label"][0].'&label2='.$value["label"][1].'&periode='.$my_period.'">'.$value["titre"].'</a> ('.$tmp.')'; } else { $href='href="cluster.php?id_cluster='.$value["id"].'&periode='.$my_period.'"'; $groupes_clusters[$key]["href"]='<a '.$href.'>'.$value["titre"].'</a> <a class="dead" '.$href.'>'.$value["homos"][0]["arrows"].'</a>'; }
<? // $query="SELECT slider_val FROM tbl_slider WHERE user='******'ID_my_site']."'"; // echo $query; // $result=mysql_query($query); // $row=mysql_fetch_array($result); // $pertinence = $row['slider_val']; // $pertinence =intval($pertinence)/100; $commande_sql_pert = "SELECT id_billet,overlap_size,billet_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=".$pertinence.' and overlap_size/cluster_size>0.1 '.' ORDER BY overlap_size/cluster_size/log10(10+billet_size-overlap_size) DESC'; // echo $commande_sql_pert; $res_temp = mysql_query($commande_sql_pert); $liste_of_posts=array(); $liste_of_size=array(); //echo "\n<p><table width=100%><tr valign=top><td width=95%>"; echo ' <table class=tableitems width=100% cellspacing=0 cellpadding=1 style="font-variant:small-caps;">'; echo '<tr valign=top>'; // PANEL DE GAUCHE: PERIODES PRECEDENTES left_panel($p,$pred,$nopred,$backdarker,$backdark); echo '<td width=1%></td>';
$check2 = mysql_num_rows($resultat); if ($check2==0) { echo "<div class=subbanner><b>nb: ce terme n'apparaît dans aucun champ thématique pour la période ".get_string_periode(arrange_periode($periode))."</b></div>"; } while( $row = mysql_fetch_array ( $resultat )) { $id_cluster = $row [ 'id_cluster' ]; $ids_cluster[] = $id_cluster; $periodevar = arrange_periode($row [ 'periode' ]); } $concepts_voisins = export_concepts($ids_cluster,derange_periode($periode)); $concepts_voisins_string = get_concept_string($concepts_voisins); echo "<td width=2.5%></td></tr></table>"; //on extrait d'abord la liste totale des périodes: $total_list_periods $commande_sql = "SELECT periode from cluster GROUP BY periode"; $total_periode_sql=mysql_query($commande_sql); while ($total_periode_sql_i=mysql_fetch_array($total_periode_sql)) { $total_periods_raw[]=$total_periode_sql_i['periode']; } $total_list_periods=sort_periods($total_periods_raw);
while ($billes2=mysql_fetch_array($resultat2)) { $label_1 = $billes2['forme_principale']; } $commande_sql2 = "SELECT forme_principale from concepts where id = '".$billes['label_2']."'"; $resultat2=mysql_query($commande_sql2); while ($billes2=mysql_fetch_array($resultat2)) { $label_2 = $billes2['forme_principale']; } $cluster_name =$label_1.' - '.$label_2.' ('.$id_cluster.', '.$my_period.')'; } $commande_sql = "SELECT id_billet from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."'"; $resultat=mysql_query($commande_sql); while ($billes=mysql_fetch_array($resultat)) { $billet_index = $billes['id_billet']; $sql_auteur = "SELECT auteur_id,site from billets where id = '$billet_index'"; $res_auteur=mysql_query($sql_auteur); while ($sql_auteurs=mysql_fetch_array($res_auteur)) { $auteurs[] = $sql_auteurs['auteur_id']; $legende[$sql_auteurs['auteur_id']]=$sql_auteurs['site']; } } $aut_occ = array_count_values($auteurs); //print_r($aut_occ);
$d_c=date("Y-m-d", strtotime($newd)); //commentaire echo "<td>"; echo $dt."</td><td width=40%>".'"<i>'.'<a href="'.$row['vue'].'">'.$row['commentaire'].'</a>'.'"</i>' ; //type d'objet echo "<td width=15%>"; if (intval($row['blog'])>0){ echo '<i>source</i>: '.$dictionaire_sources[$row['blog']]; } if (intval($row['concept'])>0){ echo '<i>concept</i>: '.$dictionaire_termes[$row['concept']]; } if (intval($row['cluster'])>0){ $resultats=mysql_query("select label_1, label_2 FROM cluster WHERE id_cluster=".$row['cluster']." AND periode = '".derange_periode($row['periode'])."' GROUP BY identifiant_unique") or die ("Requête non executée."); while ($lignes=mysql_fetch_array($resultats)){ $cluster_name=$dictionaire_termes[$lignes['label_1']].'-'.$dictionaire_termes[$lignes['label_2']];} echo '<i>cluster</i>: '.$cluster_name; } if (intval($row['cluster'])+intval($row['concept'])+intval($row['blog'])==0){ $urs = explode("?", $row['vue']); $vue = $urs[0]; $urs = explode("/", $vue); $vue = end($urs); if ($vue=="entree_sources.php") $vue_txt='liste des sources'; if ($vue=="entree_clusters.php") $vue_txt='liste des clusters'; if ($vue=="entree_termes.php") $vue_txt='liste des termes'; if ($vue=="phylo.php") $vue_txt='liste des fils thématiques'; if ($vue=="global.php") $vue_txt='carte';
<? //$commande_sql_pert = "SELECT id_billet,overlap_size,billet_size,cluster_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=".$pertinence.' and overlap_size/cluster_size>0.1 '.' ORDER BY overlap_size/cluster_size/log10(10+billet_size-overlap_size) DESC'; //$commande_sql_pert = "SELECT id_billet,overlap_size,billet_size,cluster_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=0.1 AND overlap_size/cluster_size>0.1 ORDER BY overlap_size/cluster_size/log10(10+billet_size-overlap_size) DESC"; $commande_sql_pert = "SELECT id_billet,overlap_size,billet_size,cluster_size from biparti where cluster = '".$id_cluster."' AND periode = '".derange_periode($my_period)."' AND overlap_size/cluster_size/log10(10+billet_size-overlap_size)>=0.1"; $res_temp = mysql_query($commande_sql_pert); $liste_of_posts=array(); $liste_of_size=array(); echo ' <table class=tableitems width=100% cellspacing=0 cellpadding=1 style="font-variant:small-caps;">'; echo '<tr style="height:20px;"><td></td></tr>'; echo '<tr><td width=100% style="height:1px;background-color:SlateGray;"></td></tr>'; echo '<tr style="height:10px;"><td></td></tr>'; echo '<tr valign=top>'; echo '<td align=left width=100%>'; ///////////////////////////////////////////// ///// ///// ///// ///// ///// ///// ///// DEBUT DE L'AFFICHAGE DES BILLETS ///// ///// ///// ///// ///// ///// ///// ///////////////////////////////////////////// echo '<table class=tableitems width=100% cellspacing=0 cellpadding=3>'; echo '<tr>'; echo '<td align=left style="font-variant:small-caps; font-size:x-small; font-weight:bold;">ENSEMBLE DES BILLETS ASSOCIÉS AU CHAMP AU-DELÀ DU SEUIL DE PERTINENCE</td>'; echo '<td width=5%></td>'; $jscriptmp.=' var select = $( "#pertinence" ); var slider = $( "#slider" ).slider({
if(isset( $_GET['periode'])) $my_period=$_GET['periode']; else $my_period=arrange_periode(end($list_of_periods)); $titleheader="liste des champs (".get_short_string_periode($my_period).")"; include("include/header.php"); include("banner.php"); //clause qui signale qu'on est à la dernière période if ($list_of_periods[count($list_of_periods)-1]==$my_period) {$clause_fils_pere = '';} else {$clause_fils_pere = ' AND nb_sons+nb_fathers>='.$orphan_filter;} $quer="select id_cluster,label_1,label_2,periode, nb_sons,nb_fathers FROM cluster WHERE periode ='".derange_periode($my_period)."'".$clause_fils_pere." GROUP by id_cluster ORDER by periode, label_1, label_2, id_cluster"; $resultat=mysql_query($quer) or die ("<b>Requête non exécutée (mysql query)</b>."); while ($ligne=mysql_fetch_array($resultat)){ $periode=arrange_periode($ligne['periode']); $liste_termes_brute[] = "<b>".$dico_termes[$ligne['label_1']]."</b> - ".$dico_termes[$ligne['label_2']]; $liste_termes_brute_id[]=array($ligne['label_1'],$ligne['label_2']); $id_termes_brute[] = $ligne['id_cluster']; $fils[] = $ligne['nb_sons'] ; $pere[] = $ligne['nb_fathers'] ; } $resultat=mysql_query("select periode FROM cluster GROUP by periode ORDER by periode") or die ("<b>Requête non exécutée</b>."); while ($ligne=mysql_fetch_array($resultat)){ $periode_termes_brute[]=$ligne['periode'];}
echo '<table width=100% class=tableitems>'; echo '<tr valign=top><td width=2.5%></td>'; echo '<td width=95%>'; $jscriptmp.="$('.bigscrollPane').scrollbar;"; echo '<div class="bigscrollPane">'; echo '<table width=100% class=tableitems><tr>'; echo '<td width='.$widthcolumn.'%>'; if ($my_period!=-1) { if ($clause_fils_pere=='') $query_extension="WHERE periode ='".derange_periode($my_period)."'"; else $query_extension="WHERE periode ='".derange_periode($my_period)."' AND ".$clause_fils_pere; } else { if ($clause_fils_pere=='') $query_extension=""; else $query_extension="WHERE ".$clause_fils_pere; } $resultat=mysql_query("select concept FROM cluster ".$query_extension) or die ("Requête non exécutée."); $liste_terme_cluster=array(); while ($ligne=mysql_fetch_array($resultat)){ if (!in_array($dico_termes[$ligne['concept']],$liste_terme_cluster)) {$liste_terme_cluster[]=$dico_termes[$ligne['concept']];} }