如何在pdo php中编辑数据库中的连接数据

failure to update data from join please team help me so as to update

 $result =  "UPDATE manager m INNER JOIN user u ON
          m.manager_phone='$manager_phone', m.manager_fax='$manager_fax', m.manager_email='$manager_email', u.fullname='$fullname', u.address='$address',
                u.occupation='$occupation' WHERE manager_id='$id'";

        $stmt = $connpdo->prepare($result);
        $stmt->execute();
       if ($stmt)
       {
           echo "ok";
           exit;
       }
       else
       {
           echo "fail";
           exit;
       }

Your statement is malformed and there is no SET statement. Is this what you wanted?

  $result =  "UPDATE manager m 
          INNER JOIN user u ON m.manager_id = u.user_id
          SET m.manager_phone='$manager_phone', 
          m.manager_fax='$manager_fax', 
          m.manager_email='$manager_email', 
          u.fullname='$fullname', 
          u.address='$address',
          u.occupation='$occupation' 
          WHERE manager_id='$id'
  ";