Search 2 fields in a Drupal content type

Question

Hello.

I need a simple search form on my Drupal site but I can't figure out the best way to get it done. Basically I have a content type with a couple of different fields and I want my form to search in both the title and the body and then return a list with the title its picture and the stripped body.

I have tried with Views and it works fine and ajaxy except there are two fields - one for the title and one for the body.

Do I make my own module with a little sql and whatever else is necessary or is there a way to get Views to do it for me?

Answer 1

The solution I used for a similar case sounds strange, but in the global price of preformance/coding/space, it is a great and simple solution.

The solution is here.

in few words:

• Use computed CCK field to combine all of the fields you want to search on.
• Write a small AJAX to search on the computed field.
• Create a view that will show the original fields and not the computed field.

Good luck, Let me know if you need further help.

Answer 2

You can also do a custom search form, which will show your custom results, which can be extracted with your own SQL queries (combining the fields and such).

Are you sure your current search is not already looking in the title and body field??