Answers

• allan Posts: 65,298Questions: 1Answers: 10,826 Site admin

  February 2016 Answer ✓

  Hi,

  Yes, unfortunately that wouldn't work since it would effectively cope out like: WHERE unit IN ('4210, 4211') (note the string quotes).

  I've just had a look at the PHP documentation and I don't actually see a way of doing what you want with the PDO methods. What you would probably need to do is use or_where and loop over your array of values. Using IN is probably only useful if you get the results from an inner SELECT.

  Allan
• Alchetec Posts: 14Questions: 5Answers: 0

  February 2016

  That worked. So others see the complete solution, this is how I changed things:

  $q->or_where( function ( $r ) {
     global $units;
     foreach ($units as $unit) {
        $r->or_where( 'unit', $unit );
     }
  } );