PHP/MySQL Select Statement

Question

This one's probably easy:

I have two variables:

$sender_id
$receiver_id

Those ID's are stored and assigned to a user in tblusers. I have no problem selecting one-at-a-time:

$data = mysql_query("SELECT * FROM tblusers WHERE usrID='$receiverID'") or die(mysql_error());

while($row = mysql_fetch_array( $data ))
{
echo $row['usrFirstName'];
echo $row['usrLastName'];
}

However, how would I select both rows (one for senderID and receiverID) so that I can gain access to further information on both those users. Sort of like a "SELECT within a SELECT".

Thanks!

Brian Ramsay · Accepted Answer · 2009-07-28 16:23:46Z

5

SELECT * FROM tblusers WHERE usrID='$receiverID' or usrID='$sender_id'

EDIT: clarification

while($row = mysql_fetch_array( $data ))
{
    if($row['usrID'] == $receiverID) {
        echo "Receiver: " . $row['usrFirstName'] . " " . $row['usrLastName'];
    } else {
        echo "Sender: " . $row['usrFirstName'] . " " . $row['usrLastName'];
    }

}

answered Jul 28, 2009 at 16:23

Brian Ramsay

7,6958 gold badges43 silver badges52 bronze badges

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

1 Comment

Dodinas Over a year ago

Thanks for the reply. So, in my "while" statement, how would I differentiate between the $senderID and $receiverID, if I wanted to refer to one specifically.

Eric · Accepted Answer · 2009-07-28 16:28:51Z

2

If you need to differentiate which is the receiver and which is the sender:

select
    'Receiver' as UserType,
    *
from
    users
where
    usrid = $receiver_id
union all
select
    'Sender' as UserType,
    *
from
    users
where
    usrid = $sender_id

This will return:

UserType  |  UsrID  |  Name
Receiver  |   23    |  John Smith
Sender    |   42    |  Adam Douglas

Of course, with two rows, you can always just compare the ID's to figure that out, too. This is mainly to make scaling easier if you have a larger result set than just two rows.

answered Jul 28, 2009 at 16:28

Eric

95.7k13 gold badges117 silver badges116 bronze badges

Comments

bobflux · Accepted Answer · 2009-07-28 16:48:45Z

0

SELECT * FROM tblusers WHERE usrID IN ($receiverID, sender_id)

answered Jul 28, 2009 at 16:48

bobflux

11.6k3 gold badges31 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL Select Statement

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related