simple yet not working?

[JamesGMills]

Hi...

I am trying to run this:

SELECT * from phpbb_users WHERE user_id <> '-1' AND user_active = '0' OR user_posts = '0'

Sure you can see what i am trying to do with phpbb forum users table but in the results it always picks up the user with id -1

Is my SQL wrong?

------------------------

http://www.jamesmills.co.uk

 

[feherke]

Hi

Maybe

SELECT * from phpbb_users WHERE user_id <> '-1' AND [red]([/red]user_active = '0' OR user_posts = '0'[red])[/red]

http://dev.mysql.com/doc/refman/4.1/en/operator-precedence.html

Feherke.

http://rootshell.be/~feherke/

 

[JamesGMills]

Hi, nice work!

Thanks very much!

------------------------

http://www.jamesmills.co.uk