Whats Wrong in query?

[takn25]

Hi, I am fairly new to using OR in my queries and for some reason the result isnt what it should be please could you check the result should be NULL (0) I did an echo and it shows 1 with num rows.

 

Ok in the mysql table the played row = 0 and c1 = 1 and c2 = 5

 

$cid=1;

$post = "SELECT * FROM match WHERE c1 ='$cid' OR c2 = '$cid' && played ='7'";	

$post_result= mysql_query($post) or die (mysql_error());
while ($row_post=mysql_fetch_assoc($post_result))

{
$id=$row_post['match_id'];
}

$post_num=mysql_num_rows($post_result);
echo $post_num;

[Lyleyboy]

Could be && in your query instead of AND

[betterphp]

I think AND takes priority over OR so you are efficiently doing

 

$post = "SELECT * FROM match WHERE c1 ='$cid' OR (c2 = '$cid' && played ='7')";

 

now I have written that I'm not sure though. the && should defiantly be AND. Although it should give an error if that was wrong.

[Maq]

Also, 'match' is a MySQL reserved word.  You either need to change your column name, along with your queries

OR

put backtics `match` around it in all your queries.

 

This seems to be a MySQL question, moving.

 

[mikosiko]

+1 with Maq answer...

 

and for the &&, AND and OR operators and precedence you can read:

 

http://dev.mysql.com/doc/refman/5.0/en/expressions.html

 

and

http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html