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?