Buy Now
Sign in

How do I use 'WHERE .. IN' selector in a read data

NickOg , October 07 at 20:31
NickOg

I am trying to use a WHERE .. IN selector in a read data set-up so:-

				<?php
$whereConditions= getSelectedReceipts($this->data['loader']);
return $whereConditions;
?>


with this function
				function getSelectedReceipts($thisDataRead) {
foreach ($thisDataRead as $aReceipt) {
if (!isset($receiptSelector)) {
$receiptSelector = $aReceipt['mdlPrgReceipts']['idReceipt'];
} else {
$receiptSelector .= ',' . $aReceipt['mdlPrgReceipts']['idReceipt'];
}
}
$receiptSelector='7695,7684'; // This just for test purposes
$selector=['mdlPrgReceipts.idReceipt', "$receiptSelector", 'IN'];
return $selector;
}


I can't work out where this error arises.

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'B> ' Illegal string offset \'mdlPrgReceipts\' in <b>/hsphere/local/home/pmhu3ad' at line 1



Is that
				$selector=['mdlPrgReceipts.idReceipt', "$receiptSelector", 'IN'];
				
correctt?


Regards

Nick