PHP - Mysql select AND OR

Question

I have this PM system, where users can write each other. When I show the available PM's I have in my MySQL table deleted_sender and deleted_receiver

If the deleted_sender is 1, then the person who sent the PM shouldn't be able to see it in the list. If the deleted_receiver is 1, then the person who received the PM shouldn't be able to see it.

My question is, how can I do this with a mysql query? Currently I have this:

$r=mysql_query("
         SELECT * FROM private_messages 
         WHERE 
           sender_id='".$userdata['id']."' 
         OR 
           receiver_id='".$userdata['id']."' 
         AND 
           (deleted_receiver='0' OR deleted_sender='0')");

Although, this just shows the PM at both the sender and the receiver.

I am not sure why you want to write single query, see both sender or reciever are seperate entity, and you only want to show a result to either of them. if it is deleted for sender, then don't show to sender by show to reciever. so put only one condition i.e. either for sender or for reciever. — Sumit Gupta
– Sumit Gupta, Commented Sep 24, 2013 at 12:29
check if $userdata['id'] is sender then query with deleted_sender =0 vice versa for receiver — M Khalid Junaid
– M Khalid Junaid, Commented Sep 24, 2013 at 12:29

Niet the Dark Absol · Accepted Answer · 2013-09-24 12:29:39Z

3

Well, think about what you're trying to do: you want to show it to the sender if the sender hasn't deleted it, and vice versa for the receiver.

In other words, you want to show if
(sender = user AND sender hasn't deleted) OR (receiver = user AND receiver hasn't deleted)

From this you build your query:

... WHERE (`sender_id`={$userdata['id']} AND `deleted_sender`=0)
       OR (`receiver_id`={$userdata['id']} AND `deleted_receiver`=0)

answered Sep 24, 2013 at 12:29

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

Comments

Adrien Gorrell · Accepted Answer · 2013-09-24 12:38:53Z

0

    $r = mysql_query(
"SELECT * FROM private_messages 
WHERE (sender_id='".$userdata['id']."' AND deleted_sender='0') 
OR (receiver_id='".$userdata['id']."' AND deleted_receiver='0')"
);

Also this may end in invalid results since you don't know then if your result is about send or receive... depends on the display you like. But you may have to make two different requests.

edited Sep 24, 2013 at 12:38

answered Sep 24, 2013 at 12:30

Adrien Gorrell

1,3193 gold badges15 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP - Mysql select AND OR

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related