Scriptje

<form name="form1" method="post" action="index.php?page=zieverkoop">
  <table width="100%"  border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="39%" height="39" valign="top"><p>Zie verkopen van:<br>          
        <select name="select">
            <option selected>Alle verkopen</option>
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
            <option>8</option>
            <option>9</option>
            <option>10</option>
            <option>12</option>
            <option>13</option>
            <option>14</option>
            <option>15</option>
            <option>16</option>
            <option>17</option>
            <option>18</option>
            <option>19</option>
            <option>20</option>
                  </select>
        </p>      </td>
      <td width="61%" valign="top"><p>Sorteer op<br>
        <input name="radiobutton" type="radio" value="nummer">
        Nummer
        <br>
        <input name="radiobutton" type="radio" value="prijs">
Prijs<br>
<input name="radiobutton" type="radio" value="id"> 
Volgorde van verkoop
</p>      </td>
    </tr>
    <tr>
      <td><input type="submit" name="Submit" value="Zie verkopen">        <br>      </td>
      <td>&nbsp;</td>
    </tr>
  </table>
</form>

<?PHP

$selectie = $_POST['select'];
$sort = $_POST['radiobutton'];


$user="beurs_db";
$host="db2.awardspace.com";
$password="banaan";
$database="beurs_db";
$connection = mysql_connect ($host, $user, $password)
			or die ("Kon geen verbinding maken");
$db = mysql_select_db($database, $connection)
			or die ("Kon database niet selecteren");

if($selectie == "Alle verkopen")

{	
$query = "SELECT * FROM nummers";
$result = mysql_query ($query)
		or die(mysql_error());
}
else
{
$query = "SELECT * FROM nummers WHERE nummer = '$selectie'";
$result = mysql_query ($query)
		or die(mysql_error());
}

echo "<center><BR>";

echo "<table border='1' cellpadding='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#000000' width='90%' id='AutoNumber3'>
  <tr>
    <td width='10%'><strong>Nummer</strong></td>
    <td width='90%'><strong>Prijs</strong></td>
  </tr>";

while ($row = mysql_fetch_array($result))
{
	extract($row);
	echo	"<tr>
    <td width='10%'><p>        $nummer<br>
    </p></td>
    <td width='90%'>&euro; $prijs </td>
  </tr>


";

echo"</TABLE><BR>";

}
echo "</center>";
?>