MySql query help

[Derek_Trotter]

Hi,
How can I modify this query:

SELECT thread.title, post.username, post.threadid, post.postid, TIME_FORMAT(time(from_unixtime(post.dateline )), '%H:%i')AS PostTime from post left join thread on post.threadid =thread.threadid order by post.postid desc limit 5

I want to extract last 5 posts, from deferent threads.
(Something like on New Posts search)

Thanks

[punchbowl]

what's wrong with it? I ran it and got what looks like the last 5 posts on my board?

[Derek_Trotter]

Ups, I didn't check tread table. I think I can find solution.
Sorry for stupid question

--------------- Added [DATE]1228731093[/DATE] at [TIME]1228731093[/TIME] ---------------

Originally Posted by punchbowl

what's wrong with it? I ran it and got what looks like the last 5 posts on my board?

I wanted 5 post to be with distinct threads titles. Don't need thread titles to be repeated.