Pb of LIMIT

[Anon]

Hi. This querry doesn't work in my PHP page : SELECT FROM acturesto ORDER BY date DESC, LIMIT 1
This one works well : SELECT FROM acturesto ORDER BY date DESC
So, how should I specify that I only want to show the most recent article of my database ?
Thanks for answers.

[marcel]

I dont konow if your SQL server knows about LIMIT'...
in any case you shoul cut the,'(COMMA)
so...
SELECT * FROM acturesto ORDER BY date DESC LIMIT 1

[amcgrath]

Lose the comma after DESC.

[Anon]

yes, the pb came from the coma. Thank you.