$sql = "UPDATE `users` 
           SET(`uname` = :uname,`role` = :role,`fname` = :fname,`email` = :email,`mobile1` = :mobile1,`mobile2` = :mobile2,`education` = :education,`division` = :division,`district` = :district,`sub_district` = :sub_district,`address` = :address,`looking_for` = :looking) 
         WHERE `id` = :id";

            //$sql = "UPDATE `users` SET(`uname`=?,`role`=?,`fname`=?,`email`=?,`mobile1`=?,`mobile2`=?,`education`=?,`division`=?,`district`=?,`sub_district`=?,`address`=?,`looking_for`=?) WHERE `id`=?";
            $st = $conn->prepare($sql);
            //$res['sql'] = $st->queryString;
            $params = array(
                ':uname' => $uname,':role' => $role,':fname' => $fname,':email' => $email,':mobile1' => $mobile1,':mobile2' => $mobile2,':education' => $edu,':division' => $division,':district' => $district,':sub_district' => $sub_district,':address' => $address,':looking' => $looking,':id' => $id
            );

            //$res['params'] = $params;
            $r = $st->execute($params);

得到：

sqlSTATE[42000]: Syntax error or access violation: 1064 You have an
error in your sql Syntax; check the manual that corresponds to your
MariaDB server version for the right Syntax to use near ‘(uname =
‘rahman@abc.def’,role = ‘2’,fname = ‘A full Name’,email = ‘rahm’
at line 1

谁能告诉我我的代码有什么问题？

这是我的表结构：