Using multiple AND's and OR's
Posted on 2012-08-15
I have the following query which basically, I want it to do the following:
select the field tblhostingaddons where the status is pending and the hostingid is 1
select one that has either the addonid 1 or the addonid 2.
The conditions that the status is pending and the hostingid is 1 must be there, but the condition for addonid can be either 1 or 2.
This is my query:
"SELECT id FROM tblhostingaddons WHERE status='Pending' AND hostingid='1' AND addonid=1 OR addonid =2"
However, it's not following my conditions that the status must be pending. It's choosing one where the status isn't pending which is wrong.
Any ideas where I'm going wrong here?