Last 10 Posts - Please help

[uasound]

I've searched the forums hundred times and didn't find the hack that would do this

I needd to show last 10 threads with the latest posts.

I have this SQL

SELECT DISTINCT thread.threadid, 
post.postid, post.username, thread.title FROM post, thread WHERE thread.threadid = post.threadid ORDER BY post.dateline DESC LIMIT 10

But it will repeat the threads and the list will show same thread several times.

How do I make this work?

Thanks, appreciate your help!

[uasound]

Anyone?

[Pimboli]

I need it too

[heynurse]

I am also looking for an easy way to show the last 10 post etc... I am using vb3, when i used vb2, there was a cool hack that would display the last XXX amount of post on a non-vb page, I haven't found one of those for vb3 yet, I'm sure it's around, just haven't located it yet

Found the hack: https://vborg.vbsupport.ru/showthrea...&highlight=vb3

EDITED TO ADD: I just found out that this same script can work with VB3, just need to modify the paths in the config file.

[Mhaddy]

Yep - I'm running vB3 RC 4 and with a little modification of the paths, this works .