--- In [email protected], "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]
>
You mast be careful with the WHERE conditions.
like:
In this part of the WHERE *** had.breed != '18' and had.breed != '19' ***
did you mean OR and not AND ... or you must have some '('.
