Php/MYSql Error in Query

Question

I there any problem on my code??? If its ok then why i am always get this error

PDOException: 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 'add = 'Myaddress' WHERE id = '' at line 7 in C:****\class\class.admin.php on line 160

Here is my Code:

function EditClient($uname,$email,$pname,$cname,$mob,$add,$cid)
    {
        $query = $this->dbh->prepare("
                UPDATE client SET 
                uname = :username,
                email = :email,
                pname = :pname,
                cname = :cname,
                mob = :mob,
                add = :addr
                WHERE id = :id ");


        $query->execute(array(
                ':username' => $uname,
                ':email' => $email,
                ':pname' => $pname,
                ':cname' => $cname,
                ':mob' => $mob,
                ':addr' => $add,
                ':id' => $cid
                )); //here is the line 160

        return $query->rowCount();
    }

Where the value of $cid is "Myaddress"

@AshishBiswas Never forget accept/upvote if answer is helpful — Sadikhasan
– Sadikhasan, Commented Jul 2, 2014 at 5:48
possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — vhu
– vhu, Commented Jul 2, 2014 at 6:00
Yep, after got this fix now i understand its look like duplicate of this question which you mentioned, but at the time when i was posting this never thought about reserve word. BTW thanks. — SmileAshis
– SmileAshis, Commented Jul 2, 2014 at 10:33

Abhik Chakraborty · Accepted Answer · 2014-07-02 05:21:11Z

2

The error is caused by using a reserved word ADD

add = :addr

You need to back-tick it

`add` = :addr

http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

answered Jul 2, 2014 at 5:21

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

1 Comment

SmileAshis Over a year ago

:P Thanks. I have totally forget this.

Sadikhasan · Accepted Answer · 2014-07-02 05:23:24Z

2

In mySql add is reserve word so you need to change

add = :addr

to

`add` = :addr

add back-tick on add keyword as mentioned above.

Check Manual for Reserve word in mysql.

answered Jul 2, 2014 at 5:23

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Collectives™ on Stack Overflow

Php/MYSql Error in Query

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related