I'm trying to take an array of ID numbers and update every row with that ID number. PHP PDO code follows:\[code\]private function markAsDelivered($ids) { $update = $this->dbh->prepare(" UPDATE notifications SET notified = 1 WHERE notification_id IN ( :ids ) "); $ids = join(',', $ids); Logger::log("Marking the following as delivered: " . $ids, $this->dbh); $update->bindParam(":ids", $ids, PDO:
ARAM_STR); $update->execute();}\[/code\]However, when this is run, only the first item in the list is getting updated, although multiple ID numbers are being logged. How do I modify this to update more than one row?
ARAM_STR); $update->execute();}\[/code\]However, when this is run, only the first item in the list is getting updated, although multiple ID numbers are being logged. How do I modify this to update more than one row?