Data Assist Search pages from Dynamic links
I am trying to setup a sequence of search and search results pages that are dynamically populated and build off each other. I have been successful with steps 1 and 3, but #2 is being stubborn!
1. products.php -- Products page includes one photo and text link for each product category.
2. Click on a Product Category photo or text link and page is redirected to products_group.php that includes all items in that product category only.
3. Click on single item to be redirected to product_detail.php
I have successfully created the basic DataAssist Wizard Search and Search Results pages and have been referring to that code to try and work out how to make these pages work. I am also referring to the bluesky solution recipe files for category and genre groups.
The products.php and products_group.php pages are setup with RepeatRegion and RepeatSelection holders populated dynamically using Recordsets and Bindings
The products.php Recordset uses just a productcategories database table with CategoryPhoto and CategoryName (primary key is CategoryID). The repeating table cell is setup as <td name="S_ProductCategoryID" id="S_ProductCategoryID">
Currently the products.php page shows the correct content, image and caption for each product category. However if I click on any item the products_group page is populated with product category 1 only, regardless of which image or link I select.
The products_group page Recordset is set to the full products database table. The image has binding to ProductImage and the text link has binding to ProductName. The page URL identifies the correct CategoryID or ProductCategoryID (their content is the same)
e.g. product_group.php?S_ProductCategoryID=1&WADbSearch1=1
e.g. product_group.php?S_ProductCategoryID=2&WADbSearch1=1
e.g. product_group.php?S_ProductCategoryID=3&WADbSearch1=1
etc. But is in fact only showing group 1 each time.
I have checked the DataAssist Search Parameters. Currently there is one column selected ProductCategoryID with column type Text, Comparison =, type: value, Value: S_ProductCategoryID.
Trigger: isset($_GET["Search_x"]) && $_GET["Search_x"]
The trigger I copied from the DataAssist created search_results page which successfully filters by Category
I copied the same Recordset SQL from basic search_results to product_group
SELECT ProductID, ProductSKU, ProductName, ProductPrice, ProductWeight, ProductCartDesc, ProductShortDesc, ProductImageLarge, ProductThumb, ProductImage, ProductCategoryID, ProductUpdateDate, ProductStock, ProductLive, ProductUnlimited, ProductLocation
FROM products
ORDER BY ProductSKU ASC
I have spent days on this going around in circles. Help!
Attached: the successful search and results php pages, the products and products_group php pages. Also some screen grabs showing the populated products.php page, the incorrect content on products_group.php page, the correct content on search_results.php