MySQLi delete behaviour multiple parameters

Hello there

I am looking to insert a MySQLi delete behaviour with multiple parameters - I have looked at the tutorial but I don't entirely follow - as well as adding the extra parameter as shown (which is simple), surely I have to add another variable?
The tutorial does not show this - the only WHERE in the query is still the email - is this correct?
How do I add another WHERE parameter please - if indeed I do?

Many thanks

yes, the finished example in the tutorial is:
$DeleteQuery->bindParam("s","".($_GET['UserEmail']) ."");
$DeleteQuery->bindParam("i","".($_GET['UserID']) ."");


meaning that it is passing the first perimeter as a sting using the UserEmail URL variable. the second parameter is passed as an integer (i) using the UserID URL variable.

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

"obviously as a normal MySQL query this would be straightforward"

not really that obvious actually, how would you do it in in a normal MySQL query?

MySQLi really isn't that different from MySQL.

you're example code above looks like it should work as long as the WADALastBatchNo recordset code is before the delete and it is properly filtering.