Show 5 latest threads

[Sharif]

How can I show the 5 newest threads (meaning with the latest posts) at a part of my site? Like what kind of mysql query would this take?

[Paul M]

You might want to edit the typo in the title of this thread ;)

[Sharif]

oy what a screwup

[Sharif]

Anyone? I am trying to just show the 5 latest threades in descending order and when people click on the title of the thread they can view it.

[deathemperor]

something like this: SELECT * FROM " . " TABLE_PREFIX " . "threads ORDER BY dateline LIMIT 5

well if you knew what you have to do.