Mysql Query "OR" and "AND"

Question

$assault_checker=mysql_query("SELECT * FROM assaults WHERE host_id='".$_SESSION['user']."' OR guest_id='".$_SESSION['user']."' AND status='0'");
$assault_checker=mysql_num_rows($assault_checker);

I keep getting the wrong expected result. I just want to count the number of rows where the user id is in host_id or guest_id. Also the status row should be 0.

What am I missing?

Your next stop should be finding out how to protect your program and avoid sql injection. — Marged, Dec 16 '15 at 22:46

score 3 · Accepted Answer · answered Dec 16 '15 at 19:38

3

yes you should use brackets, your query should be:

$assault_checker=mysql_query("SELECT * FROM assaults WHERE (host_id='".$_SESSION['user']."' OR guest_id='".$_SESSION['user']."') AND status='0'");

answered Dec 16 '15 at 19:38

Gouda Elalfy

6,888
1
26
38

Thanks! Works like a charm – Diogo Alpha Dec 16 '15 at 19:44
Here is [documentation on operator precedence](http://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html) – Mifeet Dec 16 '15 at 22:32

Mysql Query "OR" and "AND"

1 Answers1