Getting last 12 records

[audiopro]

I am trying to get just the last 12 records from a table.
I have tried this but get no results.

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

Could someone please show me the correct method?


Keith

http://www.studiosoft.co.uk

 

[hoinz]

... the last 12 records ...
last regarding what ?

you have to submit some column name here:
... ORDER BY <column> DESC LIMIT 12

hope this helps

 

[sleipnir214]

I'm suprised you haven't reported an error. The query is not well-formed.

I particular, the ORDER BY clause:

ORDER BY DESC LIMIT 12

is missing the name of the column by which the results will be ordered. It should read:

ORDER BY SomeTableColumnName DESC LIMIT 12



Want the best answers? Ask the best questions! TANSTAAFL!

 

[sleipnir214]

Sorry, hoinz. I didn't see your post while I was compiling mine.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[audiopro]

Sorry guys, me being numb.
It works a treat when the syntax is correct.

Keith

http://www.studiosoft.co.uk

 

[sleipnir214]

Where were you using this query that you did not see the syntax error?



Want the best answers? Ask the best questions! TANSTAAFL!

 

[audiopro]

It is within Perl and I only realised there was an error when I printed the number of matched rows.

Keith

http://www.studiosoft.co.uk