The Arcive of vBulletin Modifications Site.

Sharif · #1 12-31-2004, 11:16 PM

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 · #2 01-01-2005, 12:20 AM

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

Sharif · #3 01-01-2005, 12:27 AM

oy what a screwup

Sharif · #4 01-01-2005, 05:45 PM

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 · #5 01-03-2005, 05:49 AM

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

well if you knew what you have to do.