|We don't bite newbies here... much|
Perl/MySQL Problemby Anonymous Monk
|on Feb 23, 2002 at 16:16 UTC||Need Help??|
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
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
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
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