sorting a mysql table

[sgray]

Hi Guys,

Ive just put together a database to sort a list of DVD movies I have. Its all working great but I now wish to be able to sort by date added, the number of DVD's, and the number of the DVD rack I have it stored in. The following code is proving difficult.

$link_id = db_connect('dvd');
$result = mysql_query('SELECT * ' . ' FROM List' . ' ORDER BY $sort');

when I pass the variable through via index.php?sort=dvd_name it doesnt do anything (yet works great if I just put dvd_name straight into the SQL query). I know the varibale is getting there cause I can do an echo $sort and it does display what I have inputted.

any ideas?

cheers

[dnast]

$link_id = db_connect('dvd');
$result = mysql_query('SELECT * ' . ' FROM List' . ' ORDER BY '.$sort); 

Your single quotes were messed up a little. I'm not sure why you have everything broken up though.

$link_id = db_connect('dvd');
$result = mysql_query("SELECT * FROM List ORDER BY $sort");

The above would do the exact same thing.

[sgray]

sweet, working awesome now 😛