";
echo "$row[LIBELLE] ($row[SOMME])";
$result_carte = mysql_query( "select * from ZONES where ZONES.ID_PAYS='$row[ID_PAYS]' and ZONES.POS_REMP_X<>''");
if($row_carte = mysql_fetch_array($result_carte))
{
echo " ";
display_lng_text("IDX_LIEUX_MAP");
echo "";
}
echo "
";
$result_pays = mysql_query( "select ZONES.CODE, ZONES.ID_ZONE, ZONES.LIBELLE, COUNT(*) as SOMME from ZONES,INDIVIDUS where ZONES.ID_PAYS='$row[ID_PAYS]' and ZONES.ID_ZONE=INDIVIDUS.ID_ZONE_NAISSANCE and ZONES.ID_PAYS=INDIVIDUS.ID_PAYS_NAISSANCE and ID_ZONE<>'999999' GROUP BY ZONES.CODE, ZONES.ID_ZONE, ZONES.LIBELLE ORDER BY ZONES.CODE, ZONES.LIBELLE, ZONES.ID_ZONE");
while($row_pays = mysql_fetch_array($result_pays))
{
echo " ";
if(strlen($row_pays[CODE])>1)
{
echo "$row_pays[CODE] $row_pays[LIBELLE] ($row_pays[SOMME])
";
}
else
{
echo "$row_pays[LIBELLE] ($row_pays[SOMME])
";
}
}
}
affiche_pied_page(true);
?>