Cannot user WHERE id IN (multiple number)

[maartenvr98]

$id = "1,2,3,4";
$ids = implode(",", $id);
$sql = $db->query("UPDATE " . DB_PREFIX . "users SET status = " . $status . " WHERE id IN (:id)", array("id"=>$ids));

Only the first id in $idswill be updated

[RiccardoB]

I’m looking for a method to use the IN statement too.
At this moment the only way I’ve found to use a IN is to manually write the query skipping the bind (that is not the "right" solution).

[waliddoch]

Same here!
Is there any way to use the IN option for queries?

[derBoehm]

Im using this

/** * @void * * Add parameters for IN() to the parameter array * @param array for IN( ARRAY_LIST ) */ public function bindArray($prefix="filter_", $values) { $str = ""; foreach($values as $index => $value) { $str .= ":".$prefix.$index.","; $bindArray[$prefix.$index] = $value; $this->bind($prefix.$index, $value); } return rtrim($str,","); }

`$x = $db->bindArray(yourArray)
$sql = $db->query("UPDATE " . DB_PREFIX . "users SET status = " . $status . " WHERE id IN ({$x})");`