MySQL Forums :: Newbie :: Listing threads by newest posts?


Advanced Search

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


Subject Written By Posted
Listing threads by newest posts? Kyle Menigoz 02/27/2009 12:19AM
Re: Listing threads by newest posts? Peter Brawley 02/27/2009 01:23AM
Re: Listing threads by newest posts? Rick James 02/28/2009 05:47PM
Re: Listing threads by newest posts? Kyle Menigoz 03/02/2009 11:02PM
Re: Listing threads by newest posts? Kyle Menigoz 03/18/2009 03:34PM
Re: Listing threads by newest posts? Peter Brawley 03/18/2009 05:22PM
Re: Listing threads by newest posts? Kyle Menigoz 03/18/2009 05:25PM
Re: Listing threads by newest posts? Peter Brawley 03/18/2009 07:33PM
Re: Listing threads by newest posts? Kyle Menigoz 03/18/2009 07:54PM
Re: Listing threads by newest posts? Rick James 03/18/2009 09:59PM
Re: Listing threads by newest posts? Kyle Menigoz 03/19/2009 04:42AM
Re: Listing threads by newest posts? Chris Preston 03/19/2009 03:28AM
Re: Listing threads by newest posts? Guelphdad Lake 03/18/2009 08:25PM
Re: Listing threads by newest posts? Kyle Menigoz 03/18/2009 08:47PM


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.