Jason
Thank you for your answer.
Forgive me if I am not understanding this correctly but I can't see where the second parameter gets its column reference from - does the behaviour assume that the parameter has the same name as the table column?
I need to make my query look up records where one parameter is equal to one column value and the second parameter is less than a second column value.
I hope this explains what I am trying to achieve - obviously as a normal MySQL query this would be straightforward, but I am struggling with the correct syntax for the MySqli behaviour,
$DeleteQuery = new WA_MySQLi_Query($connCustomer);
$DeleteQuery->setQuery("DELETE FROM hts_partcodes WHERE partcode_category = ? AND partcode_batch < ?");
$DeleteQuery->bindParam("i", "".(isset($_SESSION['partcat'])?$_SESSION['partcat']:"") ."");
$DeleteQuery->bindParam("i", "". ($WADALastBatchNo->getColumnVal("partcode_batch")) ."");
$DeleteQuery->execute();
$DeleteGoTo = "";
if (function_exists("rel2abs")) $DeleteGoTo = $DeleteGoTo?rel2abs($DeleteGoTo,dirname(__FILE__)):"";
$DeleteQuery->redirect($DeleteGoTo);
Can you point me in the right direction please?
Many thanjs