| "; $result = mysql_query( "select COUNT(*) as SOMME from PATRONYMES,INDIVIDUS where PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME and (ASCII(upper(left(PATRONYMES.LIBELLE_ORD,1)))<65 or ASCII(upper(left(PATRONYMES.LIBELLE_ORD,1)))>90)"); $row = mysql_fetch_array($result); echo "Others ($row[SOMME]) "; $result = mysql_query( "select upper(left(PATRONYMES.LIBELLE_ORD,1)) as INITIALE, COUNT(*) as SOMME from PATRONYMES,INDIVIDUS where PATRONYMES.ID_PATRONYME=INDIVIDUS.ID_PATRONYME and ASCII(upper(left(PATRONYMES.LIBELLE_ORD,1)))>=65 and ASCII(upper(left(PATRONYMES.LIBELLE_ORD,1)))<=90 GROUP BY INITIALE"); while($row = mysql_fetch_array($result)) { echo ""; echo "$row[INITIALE] ($row[SOMME]) "; } ?> |
";
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);
?>