Update query with PDO and MySQL

Question

Im trying to write an update query with PDO only I cant get my code to execute?

try {  $conn = new PDO("mysql:host=$hostdb; dbname=$namedb", $userdb, $passdb); $conn->exec("SET CHARACTER SET utf8");      // Sets encoding UTF-8 $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   $sql = "UPDATE `access_users`          (`contact_first_name`,`contact_surname`,`contact_email`,`telephone`)        VALUES (:firstname, :surname, :telephone, :email);       ";     $statement = $conn->prepare($sql);  $statement->bindValue(":firstname", $firstname);  $statement->bindValue(":surname", $surname);  $statement->bindValue(":telephone", $telephone);  $statement->bindValue(":email", $email);  $count = $statement->execute();    $conn = null;        // Disconnect } catch(PDOException $e) {   echo $e->getMessage(); } 

Answer 1

1. Your UPDATE syntax is wrong
2. You probably meant to update a row not all of them so you have to use WHERE clause to target your specific row

Change

UPDATE `access_users`          (`contact_first_name`,`contact_surname`,`contact_email`,`telephone`)        VALUES (:firstname, :surname, :telephone, :email) 

to

UPDATE `access_users`       SET `contact_first_name` = :firstname,        `contact_surname` = :surname,        `contact_email` = :email,        `telephone` = :telephone   WHERE `user_id` = :user_id -- you probably have some sort of id