problem with or

[felito]

i want to catch the `password` of a specif email when the value of activation is 1 or 2

 

query that i am using:

 

    SELECT password FROM users WHERE email= "[email protected]" && activation=1 OR activation=2

 

this code catches all emails that have `activation = 2`, but my idea is only catch `[email protected]` if the value of `activation` is 1 or 2.

 

any idea?

 

thanks

 

[Maq]

You need parentheses:

WHERE email= "[email protected]" AND (activation=1 OR activation=2)

[fenway]

You should NEVER need to retrieve the password.