Ok, that clears it up a bit. To get the name of the category to show when a particular category is chosen you will need to do the following on the product results page:
First you will need to create a new recordset and call it categories. In the simple recordset view you will select all columns from the productcategories table. You will need to filter the recordset on the CategoryID = to the URL parameter CategoryID.
Next you will need to locate the display of the Product List text it should look like this:
php:
Product List<br />
You will need to update it to be like this:
php:
<?php if ($totalRows_categories > 0) { // Show if recordset not empty ?><?php echo $row_categories['CategoryName']; ?><br/>
<?php }else{ ?>Product List<br />
<?php } ?>
I think this will get you the result you are looking for. I'm including a screen shot of the categories recordset screen as a reference.
