MySQL INSERT query error when values are numbers

Question

I am using this code to insert into a database, however for some reason it is giving me an error now. Is there a something that needs to be done when it is numbers?

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 'replace, pick) VALUES ('8', '1', '6', '1')' at line 1

$sql = "INSERT INTO TRIPLECROWNscratch (user_id, original, replace, pick) VALUES (:user_id, :original, :replace, :pick)";
        $stmt = $dbh->prepare($sql);
        $stmt->bindValue(':user_id', $_POST['user_id'], PDO::PARAM_INT);
        $stmt->bindValue(':original', $_POST['original'], PDO::PARAM_INT);
        $stmt->bindValue(':replace', $replace, PDO::PARAM_INT);
        $stmt->bindValue(':pick', $_POST['pick'], PDO::PARAM_INT);
        $stmt->execute();

juergen d · Accepted Answer · 2015-01-26 08:34:47Z

3

replace is a reserved word and needs to be escaped with backticks.

INSERT INTO TRIPLECROWNscratch (user_id, original, `replace`, pick) VALUES ...

answered Jan 26, 2015 at 8:34

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael St Clair Over a year ago

dang those reserved words haha

Collectives™ on Stack Overflow

MySQL INSERT query error when values are numbers

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related