PHP PDO Insert problem

Question

I've hit a wall with a PDO insert:

$q = $dbh->prepare('INSERT INTO grant (grant_name, update) VALUES (?,?)');
$q->bindParam(1, $grant_name, PDO::PARAM_STR);
$q->bindParam(2, $update, PDO::PARAM_STR);
$q->execute();

I get an error:

 PHP Warning:  PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;

But I cannot find the problem. I have tried using placeholder (such as :grant_name) and using the question marks (?).

Not sure, but isn't "update" a reserved word? Try putting update in backticks. — Kerrek SB
– Kerrek SB, Commented Jul 19, 2011 at 20:05

Brad · Accepted Answer · 2011-07-19 20:12:20Z

6

Both GRANT and UPDATE have specific meanings in SQL. Try this:

$q = $dbh->prepare('INSERT INTO `grant` (`grant_name`, `update`) VALUES (?,?)');

answered Jul 19, 2011 at 20:12

Brad

164k57 gold badges380 silver badges559 bronze badges

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

Comments

Paul Sonier · Accepted Answer · 2011-07-19 20:10:02Z

1

Having a column name of UPDATE would appear to be your problem. Try quoting the column name (or changing the column name to something that's not a reserved word).

answered Jul 19, 2011 at 20:10

Paul Sonier

39.6k3 gold badges81 silver badges118 bronze badges

Collectives™ on Stack Overflow

PHP PDO Insert problem

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related