Search multiple columns via one text box
How can I get one text box to search multiple columns of a DB table?
I've got these four columns created by DA where I have had to create a text box for each:
$searchWADAtbl_product_WADbSearch1 = new WA_MySQLi_Search("WADAtbl_product","");
if (isset($_GET["Search"]) || isset($_GET["Search_x"])) {
$searchWADAtbl_product_WADbSearch1->clearSearch();
$searchWADAtbl_product_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("fld_p_name"), "s", "fld_p_name");
$searchWADAtbl_product_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("fld_p_descrption"), "s", "fld_p_descrption");
$searchWADAtbl_product_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("fld_p_collection"), "s", "fld_p_collection");
$searchWADAtbl_product_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("fld_p_manufacturer"), "s", "fld_p_manufacturer");
}
This is what I have tried, but, guess what... it didn't work =D
$searchWADAtbl_product_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("fld_p_name"), "s", "fld_p_name", "fld_p_descrption", "fld_p_collection", "fld_p_manufacturer");
I've done this before with the pre-MySQLi version of DA, but it's beaten me this time!
Also, do I need , "join"=>"AND" if I have only one search box?
Thanks.