[DA Master]

I'm currently creating my custom forum system.

Everything is fine except when the last post comes into play. I have a query that selects the most recent row from the thread and post table. However I only want the most recent one from both. I feel this is a job for the JOIN stuff but have no idea on the query to use.

Thanks in advance

[NeverMind]

Code:

SELECT
   t.id, t.title, p.id, p.title
FROM
   posts AS p LEFT OUTER JOIN threads AS t
        ON t.id=p.thread_id
ORDER BY
   p.time

this a baisc one..
just replace the names with the one you have.

[DA Master]

I guess I replace t with the name of threads table and p with posts table. I'm confused about this though...

t.id=p.thread_id

is this thread.threadid=post.threadid or

thread.threadid=post.postid

[NeverMind]

it's thread.threadid=post.threadid

[DA Master]

Originally Posted by NeverMind

it's thread.threadid=post.threadid

Thanks, however shouldnt this be forumid? I'm dragging the last post in the whole forum not just one thread.

[FiRe]

SELECT MAX(forumid) FROM forums