I am building a calendar that has a number of fields - Title, Description, Date, Location...
Having so many fields makes the search page rather cumbersome. I am looking to make the search page a simple, one textbox keyword search (ala Google) that searches all fields for the keyword entered.
I modified the part of DBFileUtil.inc that generates the html form elements to write out as INPUT TYPE="hidden" instead of INPUT TYPE="text".
I then modified the template to have one "dummy" form element that looks like this:
<INPUT TYPE="text" NAME="search_field" SIZE="30" onChange="this.form.FIELD_title.value=this.value; this.form.FIELD_description.value=this.value;">
This populates the values of all of the hidden form elements with the keyword entered into the search box. This successfully allows me to search each field by the keyword entered.
This is also where the problem begins - Lets say I do a search for foo. It looks for events where foo exists in the title AND the description AND the date AND the location... That's a problem!
The missing piece of my puzzle is how do I make the query OR instead of AND. Is this doable? Where do I need to be lookin? Any help would be greatly appreciated...
Customization
