Query

[jandrews3]

I'm having trouble with the following query:

$query = "SELECT * FROM chs_students WHERE spanish = 0 and registerm = '' or spanish = 0 and registerf = '' ORDER BY lname, fname";

 

I modified it from the following query (which is functional):

$query = "SELECT * FROM chs_students WHERE spanish = 0 ORDER BY lname, fname";

 

Is the first query valid, or can I not use AND and OR in this manner? I'm trying to select only those entries whose spanish variable is zero and either whose registerf or registerm varibales are empty. Thanks.

[Barand]

use (..)s

 

WHERE (spanish = 0 and registerm = '') or (spanish = 0 and registerf = '')

[Mchl]

And use boolean logic:

 

WHERE spanish = 0 and (registerm = '' or registerf = '')

 

Also it is possible, that empty registerm and registerf values are null. In such case use:

 

WHERE spanish = 0 and (registerm IS NULL or registerf IS NULL)