How to get the 5 latest submissions from a database?

[Christophe27]

Hi,

Does anybody know how to get the (for example) 5 latest results from a database.

I'd like to create a widget with the 5 latest photo uploads ;)

Thanks!

Christophe

[yamaharuss]

You can select the TOP 5 and sort by date field

[NogDog]

SELECT . . . ORDER BY date_time_column DESC LIMIT 5

[Christophe27]

Thanks! I'll do that. Didn't know the syntax ;)