PHP update query with syntax error

Question

Can anyone tell me why this doesnt work, and returns syntax error please?

$sql4 = "update apiStreetCheckGeneral 
         set (BBAverageSpeed, BBSuperFastBBAvailable, BBCommentary)
             values ('$averagespeed', '$superfast', '$bbcommentary') 
         where PostCode='".$values['PostCode']."'";
CustomQuery($sql4);

set them one by one instead, no other way is accepted in MySQL — user3522371
– user3522371, Commented Nov 24, 2014 at 12:59

Gordon Linoff · Accepted Answer · 2014-11-24 12:55:19Z

1

This is your query:

update apiStreetCheckGeneral set (BBAverageSpeed, BBSuperFastBBAvailable, BBCommentary)
     values ('$averagespeed', '$superfast', '$bbcommentary')
     where PostCode='".$values['PostCode'].

I am not aware of update syntax that uses a column list or values. Set each one individually:

update apiStreetCheckGeneral
     set BBAverageSpeed = '$averagespeed',
         BBSuperFastBBAvailable = '$superfast',
         BBCommentary = '$bbcommentary'
     where PostCode='".$values['PostCode']."'"

You should learn, however, to use parameterized queries especially for update statements.

answered Nov 24, 2014 at 12:55

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

Comments

Nikul · Accepted Answer · 2014-11-24 12:58:45Z

0

Use query like below

$sql4 = "update apiStreetCheckGeneral 
         set BBAverageSpeed = '$averagespeed', 
          BBSuperFastBBAvailable = '$superfast', 
          BBCommentary = '$bbcommentary'
          where PostCode='".$values['PostCode']."' ";
CustomQuery($sql4);

answered Nov 24, 2014 at 12:58

Nikul

1,0251 gold badge13 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP update query with syntax error

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