the columns names are ss_title and ss_keywords. I got code from interface then replaced the variable names with what I already had (also originally from interface). This is what was generated that was working originally:
<?php
$searchWADAss_templates_WADbSearch1 = new WA_MySQLi_Search("WADAss_templates","");
if (isset($_GET["Search"]) || isset($_GET["Search_x"])) {
$searchWADAss_templates_WADbSearch1->clearSearch();
$searchWADAss_templates_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("ss_title"), "s", "ss_title");
$searchWADAss_templates_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("ss_keywords"), "s", "ss_keywords");
}
?>
Then I just wanted to generate the code needed to get search to search thru both columns instead of using two search input fields separately. It originally generated this code thru that server behavior.
<?php
$searchRecordset2_1 = new WA_MySQLi_Search("Recordset2","0=0");
if (true) {
$searchRecordset2_1->clearSearch();
$searchRecordset2_1->setSearch(array("type"=>"Key", "comparison"=>"=", "join"=>"AND", "and"=>", ", "or"=>" ", "start_encap"=>"\"", "end_encap"=>"\""), array("ss_title", "ss_keywords"), "s", "");
}
?>
This was the original form before I took out Title field. I guess I need to change that?
<div id="Search_Basic_Default_ProgressWrapper">
<form class="Basic_Default" id="Search_Basic_Default" name="Search_Basic_Default" method="get" action="spec_sheets_results.php">
<fieldset class="Basic_Default" id="Search">
<legend class="groupHeader">Search</legend>
<div class="lineGroup">
<label for="ss_title" class="sublabel" >Title:</label>
<input id="ss_title" name="ss_title" type="text" value="<?php echo((isset($_GET["ss_title"])?$_GET["ss_title"]:"")); ?>" class="formTextfield_Medium" tabindex="4" title="Please enter a value.">
</div>
<div class="lineGroup">
<label for="ss_keywords" class="sublabel" >Keywords:</label>
<input id="ss_keywords" name="ss_keywords" type="text" value="<?php echo((isset($_GET["ss_keywords"])?$_GET["ss_keywords"]:"")); ?>" class="formTextfield_Medium" tabindex="5" title="Please enter a value.">
</div>
<span class="buttonFieldGroup" >
<input type="submit" value="Search" class="formButton unstyled" id="Search" name="Search" />
</span>
</fieldset>
</form></div>