Ordinare colonne

[brodik]

ipotizzando che la pagina si chiami index.php

<?php
$order = "id";
$mode = "ASC";
$modeid = "asc";
$modeno = "asc";
$modeco = "asc";
if(!empty($_GET['order']))
    $order = $_GET['order'];
switch($order){
case "nome";
    if(($_GET['mode'] == "asc" )
        $modeco = "desc";
    else
        $modeco = "asc";
$mode = $modeco;
break;
case "cognome";
    if(($_GET['mode'] == "asc" )
        $modeno = "desc";
    else
        $modeno = "asc";
$mode = $modeno;
break;
case "id":
default:
    $order = "id";
    if(($_GET['mode'] == "asc" )
        $modeid = "desc";
    else
        $modeid = "asc";
$mode = $modeid;
break;
}
?>

<table width="870" border= "1" align="center">
    

    <tr>
      
      <td><div align="center"><font color="#000066">[b][url="index.php?order=id&mode=$modeid"]Id[/url][/b]</font></div></td>
      <td><div align="center"><font color="#000066">[b][url="index.php?order=nome&mode=$modeno"]Nome[/url][/b]</font></div></td>
      <td><div align="center"><font color="#000066">[b][url="index.php?order=cognome&mode=$modeco"]Cognome[/url][/b]</font></div></td>
          </tr>
    <?php
$db = mysql_connect("localhost","root","");
mysql_select_db("atleti", $db);
    
$result =mysql_query("SELECT * FROM mia ORDER BY $order $mode");

while($myrow=mysql_fetch_array($result))

echo  "<tr>
<td>$myrow[Id]</td>
<td>$myrow[Nome]</td>
<td>$myrow[Cognome]</td>";
?>
    
    </tr>            
  </table>

prova... dovrebbe funzionare..