JohnnyKennedy Posted August 10, 2012 Share Posted August 10, 2012 Hey, Thanks for looking at my post. I have a quick question about how I could manage my Conversation (iPhone Style) messaging system - i.e. a private message is displayed in a stream of replies between each of the users involved. So, I have two users - A and B, who are chatting with each other. In the inbox, I'd like to have the conversation displayed but I am unsure of how to group them in a query without having each reply repeated in the result. I guess, I'm asking how can I grab all rows that have the same conversation id, and display only one result in the users inbox. The structure of my table is this: mid (unique) | title (subject) | msg (body) | from | to | to_viewed | from_viewed | to del | from_del | sendtime | readIP | sendIP | conversation Regards, Jonathan 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.