Filtering a recordset using a value from another recordset?
This recordset returns rows:
<?php
$rsAUDIO = new WA_MySQLi_RS("rsAUDIO",$csdbmysqli,0);
$rsAUDIO->setQuery("SELECT NJaudioID, NJdomainID, NJuserID, NJaudioDATEADD, NJaudioTITLE, NJaudioARTIST, NJaudioDATERELEASE, NJaudioDESC, NJaudioDELETE FROM NJaudio WHERE NJdomainID = $domainID AND NJaudioDELETE = 2 ORDER BY NJaudioDATERELEASE DESC");
$rsAUDIO->execute();?>
This recordset doesnt, despite the table containing rows that have the ID value that's referenced (NJaudioID)....
<?php
$rsAUDIOSOURCES = new WA_MySQLi_RS("rsAUDIOSOURCES",$csdbmysqli,0);
$rsAUDIOSOURCES->setQuery("SELECT NJaudiolink.NJaudiolinkID, NJaudiolink.NJaudioID, NJaudiolink.NJaudiosourceID, NJaudiolink.NJaudiolinkURL, NJaudiolink.NJaudiolinkEMBED, NJaudiolink.NJaudiolinkDELETE, NJaudiosource.NJaudiosourceTITLE, NJaudiosource.NJaudiosourceURL, NJaudiosource.NJaudiosourceICON, NJaudio.NJaudioID FROM NJaudiolink INNER JOIN NJaudiosource ON NJaudiolink.NJaudiosourceID = NJaudiosource.NJaudiosourceID INNER JOIN NJaudio ON NJaudiolink.NJaudioID = NJaudio.NJaudioID WHERE NJaudiolink.NJaudioID = ? AND NJaudiolink.NJaudiolinkDELETE = 2 ORDER BY NJaudiolinkORDER ASC");
$rsAUDIOSOURCES->bindParam("i", "".(isset($rsAUDIO->getColumnVal['NJaudioID'])?$rsAUDIO->getColumnVal['NJaudioID']:"") ."", "-1"); //colname
$rsAUDIOSOURCES->execute();
?>
So I tried this....
$rsAUDIOSOURCES->bindParam("i", "".($rsAUDIO->getColumnVal['NJaudioID']) ."", "-1"); //colname
...no change.
If I replace NJaudiolink.NJaudioID = ? with a static value, NJaudiolink.NJaudioID = 10....it works, so it's clearly related to the bindParam.
I'm trying to create a nested repeat region, but I just can't for the life of me get the second recordset to return any rows, even though they exist.
What am I doing wrong?
Thank you.
NJ
