thanks Ray
So have created the new RS
<?php
$ProductsInRange = new WA_MySQLi_RS("ProductsInRange",$DBConnection,1);
$ProductsInRange->setQuery("SELECT * FROM products WHERE ProductManufacturerID = ManIDParam");
$ProductsInRange->bindParam("i", "-1", "".($Categories->getColumnVal("ProductManufacturerID")) .""); //ManIDParam
$ProductsInRange->execute();
?>
Just not sure where/how to add return the ProductManufacturerID in the original RS?
Cheers