Deleting on 2 conditions

[kreut]

Hello,

 

Can someone please tell me the correct syntax to delete a row with 2 conditions, using the Zend delete() method?  I'd like to delete any row in assignment_questions where rows have a specific combination of question_id and assignment_id.

 

Here's what I've come up with:

 

$dbWrite->delete('assignment_questions',("question_id = $question_id" AND "assignment_id = $assignment_id");

 

Thank you.

[thehippy]

AND is being used as a logical operator and not as a string being passed to SQL, there's an extra parenthesis in there too.

$dbWrite->delete('assignment_questions',("question_id = $question_id" AND "assignment_id = $assignment_id");

 

Try something along the lines of this...

$dbWrite->delete('assignment_questions', array(
  'question_id' => $question_id,
  'assignment_id' => $assignment_id
  )
);

[kreut]

Thanks for the help with the syntax!