Go to Master Detail
I can't seem to get the Master Detail to work with MySQLi. Thanks for any help.
content.php?cID=1
MySQLi generated query
<?php
$Recordset1 = new WA_MySQLi_RS("Recordset1",$UTVjournalMySQLi,10);
$Recordset1->setQuery("SELECT feature.*, author.*, photographer.* FROM feature INNER JOIN author ON feature.author = author.aID INNER JOIN photographer ON feature.photographer = photographer.pid WHERE feature.active = '1' AND feature.cID = ? ORDER BY feature.cID DESC");
$Recordset1->bindParam("i", "".($Recordset1->getColumnVal("cID")) ."", "-1"); //WAQB_Param1
$Recordset1->execute();
?>
Thanks
Jack