Hi All

I am sure this problem is due to the mysql query, so I hope it is ok to post it here, apologies if not ..

I am trying to receive results from my database, based on several conditions, however - I keep getting unexpected results

SELECT * FROM users WHERE state = "FL OR state = "NY" OR state = "KY" 
+OR state = "Invalid" AND active != "0" ORDER BY user_id ASC LIMIT 0, 
+20
[download]

The key element in that query is the active != "0" because it is returning users regardless of that value, however the below query works fine - it is just a bit smaller

SELECT * FROM users WHERE state = "FL OR state = "NY" AND active != "0
+" ORDER BY user_id ASC LIMIT 0, 20
[download]

The last one will return users where active != "0" but the first one will not .. I'm really unsure why.

Any tips would be greatly appreciated Thanks