Results of implementation
I've created the three recordset's and for rsBands I also selected name as I needed this column for the label.
The search page is working fine when I click on a brand, it only displays the relevant categories. However, the subcategories displays all records for that specific brand and not the subcategory records based on the category selected.
Is it possible after the brand has been selected as well as the selected category that these subcategories displayed will only be related to the category selected?
Will this new search form be updated automatically on the results page?
With reference to the results page changes, should I substitute ['Name'] with ['id'] for the brand name option values; and ['CatName'] with ['CatID'] for the category name option values; and ['SCatName'] with ['SubCatID'] for the sub-category name option values?
Should I also change in the bicycles results section change as follows:
FROM
<td class="WADAResultsTableCell"><?php echo($row_WADAkpc_bicycles['BicycleBrandName']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAkpc_bicycles['BicycleCatName']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAkpc_bicycles['BicycleSubCatName']); ?></td>
TO
<td class="WADAResultsTableCell"><?php echo($row_WADAkpc_bicycles['BicycleBrandID']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAkpc_bicycles['BicycleCatID']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAkpc_bicycles['BicycleSubCatID']); ?></td>
Appreciate your help Jason