Get last 12 records from table

[audiopro]

I am trying to get the last 12 records from a table and thought it could be done like this.

SELECT TITLE, ARTIST, STYLE, MEDIUM, FORMAT, CATEGORY, WIDTH, HEIGHT, SPRICE, FILENAME, NUM FROM PICTURES WHERE CUSNUM='YES' AND ARTALLOW<>'NO' ORDER BY DESC LIMIT 12

No results are returned, what is the correct method?

Keith

http://www.studiosoft.co.uk

 

[audiopro]

Sorry posted in wrong forum

Keith

http://www.studiosoft.co.uk

 

[monksnake]

Not sure what this post is doing in here but it's

Select TOP 12 .........

<.