Help needed using variables in sql query

[twomt]

Problem solved... where can I deleted this?

[Fumigator]

Ideally you'd leave the original question and post the solution; that way people searching for a similar issue can see how you solved your problem.

[twomt]

Ideally you'd leave the original question and post the solution; that way people searching for a similar issue can see how you solved your problem.

absolutely right other then that the query would have worked if my big fingers wouldn't have made a mess out of the statements :P

basically you can do $query = "SELECT $abc, $def FROM ......"
but I just entered abc, def without the $ and never spotted it.

I shall leave the original message in there next time to make a fool outta myself.

[kreoton]

my sugestion is:

$sql = "SELECT field FROM table WHERE field='".$var['field']."' ORDER BY field DESC"