<?php
$res=mysql_connect( "localhost", "Catch22" );
if( ! $res ) {
   die( "Konnte nicht auf mysql_server connecten" );
  }
if( ! mysql_select_db( "serververzeichnis" ) ) {
   die( "Konnte Verbindung zur Datenbank nicht herstellen" );
  }
if( ! empty( $_POST['orderby'] ) && ! empty( $_POST['ordervalue'] ) ) {
   $query="SELECT * From server WHERE ".$_POST['orderby']."='".$_POST['ordervalue']."' ORDER BY id DESC";
   $result=mysql_query( $query, $res );
   print "<table border=1>";
   print "<tr>";
   print "<td>Id</td>";
   print "<td>Anbieter</td>";
   print "<td>Page des Anbieters</td>";
   print "<td>Link zum Server</td>";
   print "<td>Server Art</td>";
   print "<td>Geschwindigkeit</td>";
   while( $row=mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
      print "<tr>";
      print "<td>".$row['id']."</td>";
      print "<td>".$row['anbieter']."</td>";
      print "<td>".$row['anbieterpage']."</td>";
      print "<td>".$row['serverpage']."</td>";
      print "<td>".$row['servertyp']."</td>";
      print "<td>".$row['speed']."</td>";
      print "</tr>";
     }
   print "</table>";
  }
if( ! empty( $_POST['orderby'] ) && empty( $_POST['ordervalue'] ) ) {     
   print "<form method='POST' action='".$_SERVER['PHP_SELF']."'>";
   if( $_POST['orderby']="servertyp" ) {
      print "

Voiceserver<input type='radio' name='ordervalue' value='voice'></P>";
      print "

Rootserver<input type='radio' name='ordervalue' value='root'></P>";
      print "

Gameserver<input type='radio' name='ordervalue' value='game'></P>";
     }
   elseif( $_POST['orderby']="speed" ) {
      print "

<1<input type='radio' name='ordervalue' value='k1'></P>";
      print "

>1<input type='radio' name='ordervalue' value='1'></P>";
      print "

>2<input type='radio' name='ordervalue' value='2'></P>";
      print "

>3<input type='radio' name='ordervalue' value='3'></P>";
      print "

>4<input type='radio' name='ordervalue' value='4'></P>";
      print "

>5<input type='radio' name='ordervalue' value='5'></P>";
      print "

>6<input type='radio' name='ordervalue' value='6'></P>";
      print "

>7<input type='radio' name='ordervalue' value='7'></P>";
      print "

>8<input type='radio' name='ordervalue' value='8'></P>";
      print "

>9<input type='radio' name='ordervalue' value='9'></P>";
      print "

>10<input type='radio' name='ordervalue' value='10'></P>";
     }
   print "<input type='hidden' name='orderby' value='".$_POST['orderby']."'>";
   print "<input type='submit' value='Go'>";
   print "</form>";
  }
if( empty( $_POST['orderby'] ) && empty( $_POST['ordervalue'] ) ) {
   print "<form method='POST' action='".$_SERVER['PHP_SELF']."'>";
   print "

Servertyp<input type='radio' name='orderby' value='servertyp'>";
   print "

Geschwindigkeit<input type='radio' name='orderby' value='speed'></P>";
   print "<input type='submit' value='go'>";
   print "</form>";
  }
?>