Hi all,
I have what I hope is a simple question....

I have a table with several columns, the 2 I am concerned with at the
moment are Category and Keywords.

I need to search both of these columns for a word or short phrase that
I get from a form.

For example, the search can be 'Antiques' or 'Antique Dealers'

I tried to use this

SELECT name, address, city, phone
FROM valley
WHERE keywords OR category
LIKE '%$search%'
ORDER BY name LIMIT %d,%d"

in several different ways but no joy.

When I use that snippet of code, I will get any matches from
'keywords' but nothing from category, even though I know there is a
category with the var in it....

Example:
If the form passes 'auto' and I have an entry in keywords for 'auto
dealers' and a category for 'auto repair', I will get the auto
dealers, but not the auto repair.....

Any ideas?

Thanks,
Jim