Ordinare array per alfabeto

[Queer]

ok così funge

<select name="select" class="select_rosso">
<?
$num=mysql_num_rows(mysql_query("select * from guida_locali"));
echo "<option style=\"color: ffffff;\" value=\"\">Scegli il tuo locale</option>";
echo "<option disabled=\"disabled\" value=\"\">";
$alfabeto = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','X','Y','Z');
foreach($alfabeto as $lettera) {
$num_prov=mysql_num_rows(mysql_query("select * from guida_locali where nome_locale like '$lettera%'"));
if ($num_prov > 0) {
echo "<option style=\"color: f6ff00;\" value=\"$lettera&amp;tipo=A\">$lettera ($num_prov)</option>";
$regioni=mysql_fetch_array(mysql_query("select nome_locale from guida_locali where nome_locale like '$lettera%' order by nome_locale asc"));
$query_prov=mysql_query("select distinct(nome_locale) from guida_locali where nome_locale like '$lettera%' order by nome_locale asc");
while ($province = mysql_fetch_array($query_prov)) {
$locale = $province['nome_locale'];
echo "<option value=\"$locale&amp;tipo=B\">$locale</option>";
}
echo "<option disabled=\"disabled\" value=\"\">";
}
}
?>
</select>