Hi Ray, I thought I had this working... I'm sure it was!
Anyway, I've just tested my search box and all records are being returned when I know that some should be omitted. I've just looked at the search UI and when I edit the search details shown in the list by clicking the pencil icon, the column pane shows some very strange listed items... e.g.: WADA_Insert_product or WAdbSearch1_product_results. Is this correct? Looking at your help info (yes, I have read it), it seems to show that you have DB column names whereas I seem to have session names listed.
Under the filter, I have the ability to choose 'Type: Keyword', and this changes the values of the fields beneath and allows me to choose columns from my DB there, but not all of the table's columns show despite having SELECT * in my recordset. There's 22 columns in my DB, but only about 7 showing!
Is the UI working as you would expect?
Anyway, the code I have is:
Search:
<?php
$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", "fld_p_descrption", "fld_p_collection", "fld_p_manufacturer"), "s", "search");
}
?>
Recordset (on the same page as the above search):
<?php
$WADAtbl_product = new WA_MySQLi_RS("WADAtbl_product",$conn_mrs,20);
$WADAtbl_product->setQuery("SELECT * FROM tbl_product WHERE fld_p_show = 1 ORDER BY fld_p_timestamp DESC, fld_p_id DESC");
$WADAtbl_product->execute();
?>
Search box:
<form id="Search_Basic_Default" name="Search_Basic_Default" method="get" action="rental-furniture.php">
<div class="input-group collapse">
<input id="search" name="search" type="text" value="<?php echo((isset($_GET["search"])?$_GET["search"]:"")); ?>" title="Search" placeholder="Search" class="search-box ml-auto">
<button class="btn search-btn" type="submit"> </button>
</div>
</form>
Please see images attached for behaviour of the UI.
The only change I have made is to replace the rsobj.php file you gave me for a previous file... I wonder if that is affecting it?
