Where "or" "and"

[sungpeng]

$instclasses = mysql_query("SELECT * FROM people where pid='$doin[pid]' OR cpid='$doin[pid]' AND pid='$_POST[cpid]' OR cpid='$_POST[cpid]'");

 

Am I getting the "or" "and" correct ?

[sungpeng]

$instclasses = mysql_query("SELECT * FROM people where (pid='$doin[pid]' OR cpid='$doin[pid]' ) AND (pid='$_POST[cpid]' OR cpid='$_POST[cpid]'"));

[AyKay47]

Is the query returning expected results?

[RayTaylorII]

Am I getting the "or" "and" correct ?

add Parentheses () to tell sql how to evaluate it...

 

$instclasses = mysql_query("SELECT * FROM people where pid='$doin[pid]' OR (cpid='$doin[pid]' AND pid='$_POST[cpid]') OR cpid='$_POST[cpid]'");

 

not sure if this is your intent, but you get the idea of using the "()" to control the grouping

Edited November 15, 2012 by RayTaylorII

[AyKay47]

add Parentheses () to tell sql how to evaluate it...

 

$instclasses = mysql_query("SELECT * FROM people where pid='$doin[pid]' OR (cpid='$doin[pid]' AND pid='$_POST[cpid]') OR cpid='$_POST[cpid]'");

 

not sure if this is your intent, but you get the idea of using the "()" to control the grouping

 

The OP is using () already in his second post.

Also OP, we cannot tell you whether or not the query is correct for what you are trying to do without knowing what you are trying to do.

[Barand]

Unless we hear to the contrary I think we just have to assume the second post was his solution.

Edited November 15, 2012 by Barand

[Pikachu2000]

Yeah, that would be my guess too.