MySQL Forums
Forum List  »  Newbie

Re: Listing threads by newest posts?
Posted by: Rick James
Date: February 28, 2009 05:47PM

I would say that Peter's lack of detail mocks Kyle's lack of detail. We need to see the schema you have and understand the distinction between a thread-id and a post-id. It will possibly require nested SELECTs and/or the GROUP BY trick to fetch the first (newest post, in your case) of each group.

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.