[RESOLVED] Setting MySQL ORDER BY with web form

[pianomanthree16]

I have a web form where I want to have users able to select how the MySQL database is ordered:

<select name="listord">
<option value="wayno" selected="selected">Way number</option>
<option value="name">boat name</option>
...
</select>

$ordTerms=$_GET["listord"];
$pkresult=mysql_query("select * from packetsdb order by ".$ordTerms);

For one reason or another, the results are never returned in the properly selected order. What am I missing here?

[pianomanthree16]

I discovered the error. I had multiple mysql_query statements that had not been rewritten with the order by ".$ordTerms string. The method described above does work after all.