$row_info_pays[LIBELLE]

"; $result = mysql_query( "select COUNT(*) as SOMME from INDIVIDUS where INDIVIDUS.ID_PAYS_NAISSANCE='$PAYS' and INDIVIDUS.ID_ZONE_NAISSANCE<>'999999'"); $row = mysql_fetch_array($result); $nb_ind_pays = $row[SOMME]; $result = mysql_query( "select COUNT(*) as SOMME from INDIVIDUS"); $row = mysql_fetch_array($result); $nb_ind_total = $row[SOMME]; $prc_ind = number_format(($nb_ind_pays*100)/$nb_ind_total,0); echo "$nb_ind_pays "; if($nb_ind_pays>1) { display_lng_text("CARTE_PERSONS_BIRTH"); } else { display_lng_text("CARTE_PERSON_BIRTH"); } echo " $prc_ind% "; display_lng_text("CARTE_TOTAL_IND"); echo "

"; display_lng_text("CARTE_ZONE_SELECT"); echo "

"; echo ""; mysql_query("SET OPTION SQL_BIG_SELECTS=1") or die(": FAILED"); $result_pays = mysql_query( "select ZONES.LIBELLE, ZONES.CODE, ZONES.ID_ZONE, ZONES.ID_PAYS, ZONES.POS_REMP_X, ZONES.POS_REMP_Y, ZONES.COORD_ZONE, COUNT(*) as SOMME from ZONES,INDIVIDUS where ZONES.ID_PAYS='$PAYS' and ZONES.ID_ZONE=INDIVIDUS.ID_ZONE_NAISSANCE and ID_ZONE<>'999999' GROUP BY ZONES.ID_ZONE, ZONES.ID_PAYS, ZONES.POS_REMP_X, ZONES.POS_REMP_Y, ZONES.COORD_ZONE, ZONES.LIBELLE, ZONES.CODE"); while($row = mysql_fetch_array($result_pays)) { echo "$row[CODE] : $row[LIBELLE] ($row[SOMME])"; } echo ""; echo "
"; affiche_pied_page(true); ?>