MySQL Forums
Forum List  »  Newbie

Listing threads by newest posts?
Posted by: Kyle Menigoz
Date: February 27, 2009 12:19AM

I have two tables, "forum_threads" and "forum_posts". each has an index, and I am trying to list the threads by newest post. I have gotten this to work using joins, but it lists things twice. Like, if a thread has any replies, it lists the thread the same number as there are replies.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.