Untitled

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title></title>
  </head>
  <body>


      <?php
        $pro="id";
        if(isset($_POST["odeslat"])){
        $pro=$_POST['a'];
        }
    ?>

      <table border="1">
      <?php
      mysql_connect("dbs.spskladno.cz","student20","spsnet")or die("nelze se pripojit");
      mysql_select_db ("vyuka20") or die ("databaze neexistuje".mysql_error());
      mysql_query("SET CHARSET UTF8");
      $promena=mysql_query("SELECT * FROM zoo order by ".$pro.";") or die ("prikaz se nepovedl") ;

        while(list($id,$tp,$jm,$dat,$pot,$mb)=mysql_fetch_array($promena)){
         echo "<tr>"."<td>".$id."</td>"."<td>".$tp."</td>"."<td>".$jm."</td>"."<td>".$dat."</td>"."<td>".$pot."</td>"."<td>".$mb."</td>"."</tr>";

        }
      ?>
      </table>
     <form method="post" action"">
    <input type="text" name="co" value=""> <br>
    <input type="radio" name="a" value="id" checked>ID <br>
    <input type="radio" name="a" value="typ">TYP <br>
    <input type="radio" name="a" value="jmeno">JMENO <br>
    <input type="radio" name="a" value="dat_nar">DATUM NAROZENI <br>
    <input type="radio" name="a" value="potrava">POTRAVA <br>
    <input type="radio" name="a" value="maso_bylo">MASO/BYLO <br>
     <input type="submit" name="odeslat" value="Odeslat">
     </form>


  </body>
</html>