tomdelonge Posted February 4, 2009 Share Posted February 4, 2009 Alright, I have a table called "tracking" that lists topics users track. So it has columns track_id, track_user, and topic_id. Then I have a table "messages" that has columns message_id, message_text, message_author, and topic_id. How do I return All the messages in threads so that they can all display on the same page. I know how to select rows where the user is tracking (so say it says they are tracking topics 3, 18, and 7.) How do I get all messages that have those topics ordered in an array so that it might be something like $result[0][0] is the third topic and first message and $result[3][2] is the second message in the 18th topic. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 6, 2009 Share Posted February 6, 2009 Sounds like you need a JOIN. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.