PHP PDO Statement MySQL fail on query

Question

I am having difficulty updating a table via PHP. Using MySQL prompt or a client app the SQL command works fine, yet when I attempt it in PHP using PDO it fails.

I have taken out the 'desc' field and the PHP script works. I think its getting confused with ASC/DES

$conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
$sql = "UPDATE Menu SET name=:name, desc=:desc WHERE id = :id"

$st = $conn->prepare ( $sql );


$st->bindValue( ":id",  $this->id, PDO::PARAM_INT );
$st->bindValue( ":name", $this->name, PDO::PARAM_STR );
$st->bindValue( ":desc", $this->name,  PDO::PARAM_STR );


$b = $st->execute();

Im pretty sure its just confused from field name to SQL language construct but is there a way of telling the PDO object/prepared statement that desc is a field name ?

i.e something linke

(this does not work by the way)
    $sql = "UPDATE Menu SET name=:name, \'desc\'=:desc WHERE id=:id

lll · Accepted Answer · 2012-02-07 08:11:30Z

2

You have id = 1, not id = :id

You can't bind to a parameter that doesn't exist.

Also DESC is a reserved word, you cannot use it without quoting it with backticks.

$sql = "UPDATE `Menu` SET `name`=:name, `desc`=:desc WHERE `id`=:id"

edited Feb 7, 2012 at 8:11

answered Feb 7, 2012 at 8:02

lll

12.9k3 gold badges42 silver badges60 bronze badges

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

3 Comments

IEnumerable Over a year ago

oops thanks, better fix the example, btw:this is not my actual code

IEnumerable Over a year ago

Everytime I see this online I thought it was a single quote!! now this makes sense. cheers thankyou so much. All working now

IEnumerable Over a year ago

Im new to StackOverflow, but Im learning so much here. Thanks Leigh

Collectives™ on Stack Overflow

PHP PDO Statement MySQL fail on query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related