[SOLVED] Order by DESC?

[samui]

I'm trying to order my search results descending alphabetically.

Is this the right syntax for the current MySQL version?

[php]
$res = mysql_query("SE LECT * FROM EWT WHERE $field='$findit ' ORDER BY DESC $orderby;")
or die(mysql_error ());
[/php]

Syntax is ORDER BY column_name ASC|DESC, so your statement:
[PHP]$res = mysql_query("SE LECT * FROM EWT WHERE $field='$findit ' ORDER BY $orderby DESC;") [/PHP]

Ronald :cool: