| "; $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]) "; } ?> |