ordinare in ordine albabetico i valori presi da tabella

[ubi1]

Ciao a tutti rieccomi qui a chidere info su come selezionare tramite dei tasti nel mio caso lettere dell'alfabeto i valori printati da una tabella mysql ecco il mio codice ma non riesco a farci nulla dove smaglio?

<style type="text/css">
<!--
.style2 {font-family: Arial, Helvetica, sans-serif}
.style6 {font-family: Arial, Helvetica, sans-serif; color: #FFFFFF; font-weight: bold; }
-->
</style>
<table width="80%" border="1" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="092175">
<td colspan="4" align="center">[img]img/logo.jpg[/img]</td>
</tr>

<tr>
<td colspan="4"><div align="center">A - B - C - D - E - F - G - I - L - M - N - O - P -Q - R - S - T - V - Z</div></td>
</tr>
<?php
include ('config.php');
$query = "SELECT * FROM clienti";
$rispro = mysql_query($query);
while($immob = mysql_fetch_array($rispro)){
?>
<tr>
<td width="53%" bgcolor="#6699FF"><span class="style6">Nome Azienda</span></td>
<td colspan="3" bgcolor="#6699FF"><span class="style6">Referente</span></td>
</tr>
<tr>
<td><a href="visualizza.php?cd=<?=$immob["cd"];?>" class="style2"><font size="3" >
<?=$immob["azienda"];?>
</font></a></td>
<td colspan="3" align="center">
<?=$immob["nome"];?>
</font></span></td>
</tr>
<? } ?>
</table>

grazei per l'aiuto

[lorenzos]

$immobs = substr($immob,0,1)

switch($immobs){
case "A";
$classe=a;
break;
//ecc...
}

poi passi via get la classe...

[ubi1]

e sul testo metto nel link #?

<td colspan="4"><div align="center">A - B - C - D - E - F - G - H - I - L - M - N - O - P - Q - R - S - T - V - Z</div></td>
</tr>
<?php
include ('config.php');
$query = "SELECT * FROM clienti";
$rispro = mysql_query($query);
while($immob = mysql_fetch_array($rispro)){

$immobs = substr($immob,0,1)

switch($immobs){
case "A";
$classe=a;
break;
case "B";
$classe=b;
break;
case "C";
$classe=c;
break;
case "D";
$classe=d;
break;
case "E";
$classe=e;
break;
case "F";
$classe=f;
break;
case "G";
$classe=g;
break;
case "H";
$classe=h;
break;
case "I";
$classe=i;
break;
case "L";
$classe=l;
break;
case "M";
$classe=m;
break;
case "N";
$classe=n;
break;
case "O";
$classe=o;
break;
case "P";
$classe=p;
break;
case "Q";
$classe=q;
break;
case "R";
$classe=r;
break;
case "S";
$classe=s;
break;
case "T";
$classe=t;
break;
case "V";
$classe=v;
break;
case "Z";
$classe=z;
break;
}
?>
<tr>
<td width="53%" bgcolor="#6699FF"><span class="style6">Nome Azienda</span></td>
<td colspan="3" bgcolor="#6699FF"><span class="style6">Referente</span></td>
</tr>
<tr>
<td><a href="visualizza.php?cd=<?=$immob["cd"];?>" class="style2"><font size="3" >
<?=$immob["azienda"];?>
</font></a></td>
<td colspan="3" align="center">
<?=$immob["nome"];?>
</font></span></td>
</tr>
<? } ?>
</table>

mi dice Parse error: parse error, unexpected T_SWITCH in c:\programmi\easyphp\www\elenco.php on line 22

[Razorblade]

prova a mettere i ':' dopo il 'case' al posto del ';'

[ubi1]

Parse error: parse error, unexpected T_SWITCH in c:\programmi\easyphp\www\elenco.php

fatto ma nulla da fare ti posto il codice

<td colspan="4"><div align="center">A - B - C - D - E - F - G - H - I - L - M - N - O - P - Q - R - S - T - V - Z</div></td>
</tr>
<?php
include ('config.php');
$query = "SELECT * FROM clienti";
$rispro = mysql_query($query);
while($immob = mysql_fetch_array($rispro)){

$immobs = substr($immob,0,1)

switch($immobs){
case "A":
$classe=a;
break;
case "B":
$classe=b;
break;
case "C":
$classe=c;
break;
case "D":
$classe=d;
break;
case "E":
$classe=e;
break;
case "F":
$classe=f;
break;
case "G":
$classe=g;
break;
case "H":
$classe=h;
break;
case "I":
$classe=i;
break;
case "L":
$classe=l;
break;
case "M":
$classe=m;
break;
case "N":
$classe=n;
break;
case "O":
$classe=o;
break;
case "P":
$classe=p;
break;
case "Q":
$classe=q;
break;
case "R":
$classe=r;
break;
case "S":
$classe=s;
break;
case "T":
$classe=t;
break;
case "V":
$classe=v;
break;
case "Z":
$classe=z;
break;
}
?>
<tr>
<td width="53%" bgcolor="#6699FF"><span class="style6">Nome Azienda</span></td>
<td colspan="3" bgcolor="#6699FF"><span class="style6">Referente</span></td>
</tr>
<tr>
<td><a href="visualizza.php?cd=<?=$immob["cd"];?>" class="style2"><font size="3" >
<?=$immob["azienda"];?>
</font></a></td>
<td colspan="3" align="center">
<?=$immob["nome"];?>
</font></span></td>
</tr>
<? } ?>
</table>

[lorenzos]

$immobs = substr($immob,0,1);

Manca il ;

[ubi1]

grazie ora funziona ma sul pulsante che valore devo dagli?

[lorenzos]

Il tuo codice è molto confuso,
comunque parti da questo:

<td colspan="4"><div align="center">[url="?classeconfronto=a"]A[/url] - B - C - D - E - F - G - H - I - L - M - N - O - P - Q - R - S - T - V - Z</div></td>
</tr>
<?php
include ('config.php');
$query = "SELECT * FROM clienti";    
$rispro = mysql_query($query);
while($immob = mysql_fetch_array($rispro)){

echo"
<tr>
<td width=\"53%\" bgcolor=\"#6699FF\"><span class=\"style6\">NomeAzienda</span></td>
<td colspan=\"3\" bgcolor=\"#6699FF\"><span class=\"style6\">Referente</span></td>
</tr>
";

$immobs = substr($immob,0,1)

switch($immobs){
case "A":
$classe=a;
break;
case "B":
$classe=b;
break;
case "C":
$classe=c;
break;
case "D":
$classe=d;
break;
case "E":
$classe=e;
break;
case "F":
$classe=f;
break;
case "G":
$classe=g;
break;
case "H":
$classe=h;
break;
case "I":
$classe=i;
break;
case "L":
$classe=l;
break;
case "M":
$classe=m;
break;
case "N":
$classe=n;
break;
case "O":
$classe=o;
break;
case "P":
$classe=p;
break;
case "Q":
$classe=q;
break;
case "R":
$classe=r;
break;
case "S":
$classe=s;
break;
case "T":
$classe=t;
break;
case "V":
$classe=v;
break;
case "Z":
$classe=z;
break;
}
if($classeconfronto==$classe){
echo"
<tr>
<td><a href=\"visualizza.php?cd=$immob[cd]\" class=\"style2\"><font size=\"3\" >
$immob[azienda]
</font></a>
</td>
<td colspan=\"3\" align=\"center\">
$immob[nome]
</font></span>
</td>
";
}
?> 
</tr>
<? } ?>
</table>