Nope. Still get the same error message.
I got rid of the JOINS and replaced it with the following.
<?php
$rsBatchRecords = new WA_MySQLi_RS("rsBatchRecords",$siteguide2018,0);
$rsBatchRecords->setQuery("SELECT * FROM PORC_Votes, PORC_records, aou_list WHERE PORC_records.record_number = PORC_Votes.record_number AND aou_list.SPNO = PORC_records.species_number AND PORC_Votes.member_name = ? AND (PORC_Votes.batch_date = ? OR PORC_Votes.batch_date2 = ?) ORDER BY PORC_Votes.record_number");
$rsBatchRecords->bindParam("t", "".$_SESSION['MemberName'] ."", "-1"); //colname
$rsBatchRecords->bindParam("t", "".(isset($_GET['batch_date'])?$_GET['batch_date']:"") ."", "-1"); //colname2
$rsBatchRecords->bindParam("t", "".(isset($_GET['batch_date'])?$_GET['batch_date']:"") ."", "-1"); //colname3
$rsBatchRecords->execute();
?>
I don't get any error messages now, but still no data.
If I remove the "PORC_Votes.member_name = ?" clause, I get data, but for all members. So I assume the problem is in that clause, but I can't figure out what.
