php query met dorpdownbox

[roben]

hallo, ik heb een stukje php geschreven voor mijn site. Het werkt perfect!

Hij haalt de gegevens uit de database, en zet ze mooi in een tabel.

Nu wil ik kunnen selecteren door middel van een dorpdownbox op prijs, naam, en maanden.

Dit krijg ik niet voor elkaar. Hier is mijn code:

<!------------------------------------------------------------------------------------------------------------------------------------------>

<table width="100%" border="3" bordercolor="#dc241f" align="left" bgcolor="#FFFFFF">
<tr>
<td> Naam: </td>
<td>| Provider: </td>
<td>| Kosten: </td>
<td>| Duur: </td>
<td>| Bekijken: </td>
</tr>

<?php


echo("<form action=\"http://www.simonlyzoek.nl/kpn\" method=\GET\">");
echo("<select name=\"orderen\">");
echo("<option value=\"abo_price\">Prijs</option>");
echo("<option value=\"title\">Naam</option>");
echo("<option value=\"abo_time\">Maanden</option>");
echo("</select>");
echo("<input type=\"submit\" name=\"select\">");
echo("</form>");

$order = "orderen";


$result = mysql_query("SELECT * FROM `datafeed` WHERE `provider` LIKE 'KPN' ORDER BY '$order' ");


if (!$result) {
echo("<P>Error performing query: " . mysql_error() . "</P>");
exit();
}

while ( $row = mysql_fetch_array($result) ) {

$rdescription = mb_convert_encoding($row["description"], 'HTML-ENTITIES', 'UTF-8');

echo("<tr>");
echo("<td>");
echo("</td>");
echo("</tr>");
echo("<tr>");
echo("<td>");
echo("<div id=\"Ahead\">");
echo("" . $row["title"] . "");
echo("</div>");
echo("</td>");
echo("<td>" . $row["provider"] . "</td>");
echo("<td>&euro;" . $row["abo_price"] . "</td>");
echo("<td>" . $row["abo_time"] . "&nbsp;mnd</td>");
echo("<td>");
echo("<a href=\"" . $row["url"] . "\" rel=\"nofollow\" target=\"_blank\">");
echo("<div id=\"link2\">");
echo("Bekijken... ");
echo("</a>");
echo("</td>");
echo("</tr>");
}

?>

</table>

 

[roben]

Ik heb het zo opgelost !

<!---------------------------------------------------------------------------------------------------->

echo("<form action=\"http://www.simonlyzoek.nl/kpn\" method=\"GET\">");
echo("<select name=\"sorteren\">");
echo("<option value=\"abo_price\">Prijs</option>");
echo("<option value=\"title\">Naam</option>");
echo("<option value=\"abo_time\">Maanden</option>");
echo("</select>");
echo("<input type=\"submit\" Value=\"sorteren\">");
echo("</form>");


if ($_GET['sorteren'] == "abo_price") {
$result = mysql_query("SELECT * FROM `datafeed` WHERE `provider` LIKE 'KPN' ORDER BY abo_price" );
}
elseif ($_GET['sorteren'] == "title") {
$result = mysql_query("SELECT * FROM `datafeed` WHERE `provider` LIKE 'KPN' ORDER BY title" );
}
elseif ($_GET['sorteren'] == "abo_time") {
$result = mysql_query("SELECT * FROM `datafeed` WHERE `provider` LIKE 'KPN' ORDER BY abo_time" );
}
else {
$result = mysql_query("SELECT * FROM `datafeed` WHERE `provider` LIKE 'KPN' ORDER BY abo_price" );
}