Update your SQL statement to return the ManufacturerID so you have it to compare....
Then add the new recordset with:
WHERE ProductManufacturerID = ManIDParam
and then add the parameter ManIDParam with a value of: <?php echo($Categories->getColumnVal("ProductManufacturerID")); ?>