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. Link to comment https://forums.phpfreaks.com/topic/143721-alright-how-do-i-use-results/ Share on other sites More sharing options...
fenway Posted February 6, 2009 Share Posted February 6, 2009 Sounds like you need a JOIN. Link to comment https://forums.phpfreaks.com/topic/143721-alright-how-do-i-use-results/#findComment-755796 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.