Hello,
I am looking to set up a search that can search multiple fields at once with only one search button. I saw the multisearch.php that Dave posted but I am not sure if that is what I need to use because the fields are all in the same table.
I have a distribution table and the following fields:
name,address,city,state, zip and a category menu of publications available at a location. This is what I am trying to do:
I would like to have a keyword search that will look in all fields, a search for only city, search for only zip and a search that searches the publications (note this is a category menu and I pulled that into distribution table as a list field...advanced option). I want to give the user all these options and one search button. This way they can select just one option or multiple options at the same time to narrow their search. Can you help me figure out the best way to achieve this?
Thanks!
April