php printing and updation in to db

Question

I have few values existing in data base,i need to update them but,i am unable to do it.

UPDATE Phone SET dcno='1' WHERE number='1' AND date='12/03/2009' AND dcnodate='11/05/2009' AND yourorderno='1' AND orderdate='23/06/2010' AND vendorcode='2222

Couldn't execute query: 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 ''2222' at line 3

I also need to print 3db value in to one form,i m unable to do it.

Any help ii be appreciated.

http://dpaste.com/hold/185341/

Answer 1

looks to me like you're missing the ' from the 2222.

try running that query in your database see what happens

Answer 2

There is a missing quote at the end:

vendorcode='2222

In the code the quote is missing at two places where UPDATE is being used:

....vendorcode='{$good_data['vendorcode']}'";

Answer 3

You are missing ending quote for last parameter:

"... AND vendorcode='{$good_data['vendorcode']}'";

To prevent such errors in future you should use mysqli_prepare with mysqli_stmt_bind_param. You'll find example on manual page.

Answer 4

Hello,

Here would be two solutions.

1) add vendorcode='2222';

2) remove vendorcode=2222;