good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I think your problem is that you need to tell SQL what you mean more specificaly. Right now you have
like this if conditions 1 or 2 are true 3 and 4 won't even be checked as they are irrelivent you already have a true try re-writing your statement with brackets, something like this. Written like this its saying any of the first 3 conditions may be true but must be combined with condition 4 being true (ie you active state check). Hope this helps ---If it doesn't fit use a bigger hammer In reply to Re: Perl/MySQL Problem
by vagnerr
|
|