Как решить проблему с PDO MySQL?

Question

[Школьник.]

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 '`user`='78.25.148.182'' at line 1' in C:\xampp\htdocs\lib\functions.php:234 Stack trace: #0 C:\xampp\htdocs\lib\functions.php(234): PDOStatement->execute(Array) #1 C:\xampp\htdocs\access.php(14): antibot(Object(PDO), 2) #2 {main} thrown in C:\xampp\htdocs\lib\functions.php on line 234

$mysqlx = $pdo->prepare("UPDATE `journal` SET `data` = ? WHERE `number` = 1 `user` = ?;");
$mysqlx->execute(array($j,$ip));

Answer 1

[Дмитрий Ким]

Пропустили AND:

UPDATE `journal` SET `data` = ? WHERE `number` = 1 AND `user` = ?;

Comments

[Школьник.]

Спасибо!