Creating a recordset using a value from an existing recordset value
I have a products page populated from a recordset 'rsDevInfo' using $_GET to acquire the record ID.
In the same page I want to use the value <?php echo($rsDevInfo->getColumnVal("Manufacturer")); ?> derived from 'rsDevInfo' in a new recordset where all values in my OEM columns match it.
So basically, if my current page is returning 'Sony' in the rsDevInfo recordset, I want to create another recordset showing me only those records which match 'Sony'.
I've tried a $_GET hack in a second recordset ... but doesnt return anything!
<?php
$rsRelated = new WA_MySQLi_RS("rsRelated",$MyDevDB,1);
$rsRelated->setQuery("SELECT devices.*, oems.Manufacturer FROM devices INNER JOIN oems ON devices.ProductOEM = oems.ID WHERE devices.ProductOEM=?");
$rsRelated->bindParam("i", "".$_GET['($rsDevInfo->getColumnVal("Manufacturer"))'] ."", "-1"); //oemid
$rsRelated->execute();
?>
any thoughts?