Hi Lenny,
The Correct query Syntactically is :-
Try this :- Keep all OR condition inside brackets.
SELECT * FROM ad_ads ad left join horse_ads had on ad.ads_id = had.pid WHERE
ads_category = '1' and (`ads_title` like '%Lenny%' or `ads_description` like
'%Lenny%' or had.breed = '1' or had.breed = '2' or had.breed != '18') and
(had.breed != '19' or had.breed != '20' or had.breed != '-1')
Lenny Davila <[EMAIL PROTECTED]> wrote:
I have here a mysql statement
SELECT * FROM ad_ads ad left join horse_ads had on ad.ads_id = had.pid WHERE
ads_category = '1' and `ads_title` like '%Lenny%' or `ads_description` like
'%Lenny%' or had.breed = '1' or had.breed = '2' or had.breed != '18' and
had.breed != '19' or had.breed != '20' or had.breed != '-1'
It should not find where breed is equal to 19 , but it does. These are only
2 of the fields I have in my search criteria. Please let me know the
easiest way to get the statement working correctly.
Thanks
[Non-text portions of this message have been removed]
---------------------------------
Unlimited freedom, unlimited storage. Get it now
[Non-text portions of this message have been removed]
