SELECT from 2 columns

[jfarthing]

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
CODE

SELECT name, address, city, phone
FROM valley
where keywords like '%$search%'
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

[mwasif]

What do you have in category column? Category names or category ids?

[jfarthing]

Category contains names, and keywords is a comma separated list.....