Passing variable to MySQL query

[bill1one]

In my form, I'm trying to pass the following values to a MySQL query.

Sort by:
 <select name="sort" type="text">
  <option value="Title, Author">Title</option>
  <option value="Lexile, Title">Lexile</option>
 </select>

For some reason the MySQL totally ignores the values posted and does not order the data. Here's what I have in the php page that the values are posted to.

$sort = $_POST['sort'];

$query = "SELECT Title, Author, Lexile, School FROM booklist ORDER BY ('$sort')";

I believe it has to do with the commas in the value string, but I'm not sure. I'm using MySQL 5.0 and PHP 5.1.4.

Any suggestions would be appreciated. Thanks.

 

[vacunita]

try:

$query = "SELECT Title, Author, Lexile, School FROM booklist ORDER BY [red]" . $sort[/red];

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[jpadie]

try this

$query = "SELECT Title, Author, Lexile, School FROM booklist ORDER BY $sort";

 

[bill1one]

ORDER BY $sort" worked. Thanks.