using manufacturerid to show data

On a site you've helped me with before (see PM) the shopsearch.php page attached is not filtering by the ManufacturerID - ie, if you have selected the section 'RDA' and do a search, only products that have an associated with ManufacturerID = should show. At the moment the search just shows anything that matches the searched data
http://clients.motley.site/wainwright/

It looks like the code on lines 11-31 is repeated just below it, so it can be deleted.

I don't see any code that filters based on the selected manufacturer. Maybe the code wasn't added to this page at all yet? I thought we saved a session variable with the current manufacturer and then used that to filter the recordset. This page doesn't seem to have it at all. I don't remember the database column name or session variable name we used, so I can't really give a code sample for what is missing. Maybe find it on the page where it is working.

ok, have attached a refreshed page for shopsearch.php together with the one from the product results page which works. The rs' are different and am not sure what I need to do to the shopsearch page to modify it (I dropped the rs from the product results into shopsearch and it wouoldnt return any items at all

I think you would just have to add this to your query:

AND ProductManufacturerID = ?

and then add the parameter:

$Categories->bindParam("s", "".$_SESSION['SearchMan']  ."", "1"); //manparam

And then maybe add this to the top of the page in case they hadn't set the manufacturer yet:

<?php

if (!isset($_SESSION['SearchMan'])) $_SESSION['SearchMan'] = "1";

?>

perfect. many thanks Ray