It's doable but would require a little hand coding.
The overview looks like this:
First you would need to create a link to the dynamic results for the products themselves.
If the your results for products in each result, for example, were $row_variable['clothingcompany'], I would create your link like this:
<a href="clothingmfr.php?co=<?php echo $row_variable['clothingcompany']; ?>"><?php echo $row_variable['clothingcompany']; ?></a>
What I have done above is create link using an arbitrary page and variable that you would use in the next step. As you can guess, clothingmfr.php was what I chose to be the name of the page I would create that would be for refined searches of clothing manufacturers. I then created a URL variable that will contain the manufacturers name based on what was binded from the recordset.
The next step would be to create your clothingmfr.php page.
At the top, you would then want to first simplify by your life by storing the URL variable into another variable like this:
<?php if (isset($_GET['co']) && $_GET['co'] != "") {
$company = $_GET['co'];
}
?>
This will first see if there is a URL variable and will check that it has a value. If it does, it will then store the URL variable into the variable named $company. Note, I chose co for my URL variable to represent company.
The next step would be to get the results of all manufacturers that carry that company.
This would be a simple recordset where you select all retailers using the MySQL like command.
This would look something like this (I am leaving out much of query variable needs and just showing the query itself):
SELECT retailers, anyOtherColumns FROM yourTable WHERE clothingCompany LIKE '$company'
The last part would be to loop through your results in your page.
Regards,
Brian
