Jau ilgai vargstu su kodu ir niekaip nesuprantu kame problema:
<?php
$email = "kazkas@kazkas.lt";
$group = 2;
$update = $dbh->prepare("UPDATE users SET group=:group WHERE email=:email");
$update->bindParam(':group', $group, PDO::PARAM_INT);
$update->bindParam(':email', $email, PDO::PARAM_STR);
$update->execute();
?>
gaunu klaidą:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group=2 WHERE email='
dovydas.t@hotmail.lv'' at line 1' in /home/minfas/domains/minfas.us.lt/public_html/srautas/emailconfirmation.php:36 Stack trace: #0 /home/minfas/domains/minfas.us.lt/public_html/srautas/emailconfirmation.php(36): PDOStatement->execute() #1 {main} thrown in /home/minfas/domains/minfas.us.lt/public_html/srautas/emailconfirmation.php on line 36
Puslapio adresas kuriame yra klaida:
http://minfas.us.lt/srautas/emailconfirmation.php?email=dovydas.t@hotmail.lv&key=c47662ba2504508bcdd5cb75106110a6