ORDER BY DESC problem

I am trying to retrieve data from my DB but with the most recent entry first.

If I write the code :

$query2 = "SELECT * FROM QAenquiry WHERE QAEemail='$id' ORDER BY QAEcode ";

I can retrieve the data but in the incorect order however if I write the following

$query2 = "SELECT * FROM QAenquiry WHERE QAEemail='$id' ORDER BY DESC QAEcode ";

it won't retrieve any thing. Note QAEcode is my numerical DB row number and key

The ORDER BY clause takes this syntax:

ORDER BY column direction

So your query should really be:

SELECT * FROM QAenquiry WHERE QAEemail='$id' ORDER BY QAEcode DESC