I am attempting to retrieve data and sort by a value. i.e I want the highest value first. I used DESC to reverse the order in the following text
$query_food = "SELECT * FROM MumComment WHERE
type='$_POST[interest]' ORDER BY DESC vote";
but I get the following
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC vote' at line 2
Is this because I am trying to sort numbers rather than alpha's ?
Or am I doing something extreamly stupid..