Get id of updated row in PDO

Question

I updated a row in database using PDO.

 $stmt = $db->prepare("UPDATE product SET price=? WHERE seller=?");
             $stmt->execute(array(456,"Apple"));

This didn't worked for me

$updated_id = $db->lastInsertId();

How can i get the id of that updated row.

Answer 1

Best you can do is use PDO::rowCount() to get the number of rows affected. Remember, your update statement may not update only one, so, there is no way to just get a single id.