Results 1 to 9 of 9
Jan 24, 2014, 10:07 #1
- Join Date
- Sep 2005
- 5 Post(s)
- 0 Thread(s)
Possible to do this in one query?
I have three tables:
messages (ID, subject, timestamp);
messages_users (ID, mailid, userid);
messages_replies(ID,mailid,userid, message, timestamp);
What I want to do is display a list of their messages and the user's who are involved in the conversation.
So for example I could do this in two queryies:
SELECT * FROM messages
then during the loop I could get the users
SELECT * FROM messages_users WHERE mailid = ?
loop through users and output
Is it possible to create one query for just this?