PHP inbox System

Question

I have a problem with creating an inbox System. What i'm trying to do is in "ViewMessages.php" I am trying to pull information from a MYSQL Table to show messages.

My First Statement is:

    $MessageQuery = mysql_query("SELECT * FROM messages WHERE ToUName='$ToUName' AND FromUName='$FromUName'");

But I realised a flaw, it will only show messages sent 1 way. I Tried something like:

    $MessageQuery = mysql_query("SELECT * FROM messages WHERE ToUName='$ToUName' AND FromUName='$FromUName' OR FromUName='$ToUName' AND ToUName='$FromUName'");

This failed. Can anyone shed some light to show both messages from both parties?

You are using an obsolete database API and should use a modern replacement. Don't write new code with mysql_*. — Quentin
– Quentin, Commented Nov 5, 2012 at 14:50

Arjun Abhynav · Accepted Answer · 2012-11-05 14:50:52Z

3

How about union?

$MessageQuery = mysql_query("(SELECT * FROM messages WHERE ToUName='$ToUName' AND FromUName='$FromUName') UNION (SELECT * FROM messages WHERE FromUName='$ToUName' AND ToUName='$FromUName')");

Note: If you need messages in any particular order, you can use ORDER BY at the end of the query, hoping you have something like message_id or timestamp attached to each.

answered Nov 5, 2012 at 14:50

Arjun Abhynav

5434 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

juergen d · Accepted Answer · 2012-11-05 14:58:08Z

1

SELECT * 
FROM messages
WHERE '$ToUName' in (ToUName, FromUName)
OR '$FromUName' in (ToUName, FromUName)

or if you prefer columns listed first in your query

SELECT * 
FROM messages
WHERE ToUName in ('$ToUName', '$FromUName')
OR FromUName in ('$ToUName', '$FromUName')

edited Nov 5, 2012 at 14:58

answered Nov 5, 2012 at 14:52

juergen d

205k40 gold badges305 silver badges377 bronze badges

3 Comments

Arjun Abhynav Over a year ago

You have mentioned the PHP $variable in the column place.

Daryl Gill Over a year ago

I have just tried this method, i'm using $_GET to get the information for the to and from, and if i modified ToUName to "testing" and kept the FromUName, it returned the results from the old variables.

Daryl Gill Over a year ago

SELECT * FROM messages WHERE ToUName in ('$ToUName', '$FromUName') AND FromUName in ('$ToUName', '$FromUName') just modified to that and it works. Thankyou

marianboda · Accepted Answer · 2012-11-05 14:50:49Z

1

You have boolean operators mixed up, try put some () into that.. (a AND b) OR (c AND d).

Also what you'd acomplish is getting all messages between you and the one other contact. Are you aware of that?

answered Nov 5, 2012 at 14:50

marianboda

7646 silver badges14 bronze badges

1 Comment

Daryl Gill Over a year ago

That's what I want. Its a "view message" script, where you can view the conversation between both parties

Vikas Umrao · Accepted Answer · 2012-11-05 14:51:08Z

0

Try This:

$MessageQuery = mysql_query("SELECT * FROM messages WHERE ToUName='$ToUName' || FromUName='$FromUName'");

answered Nov 5, 2012 at 14:51

Vikas Umrao

2,5801 gold badge17 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP inbox System

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related