Mysql query with a column name having '%' sign in it not executing in PHP

Question

I have a Mysql query as follows

$query = "UPDATE student_database SET fname='$fname',mname='$mname',lname='$lname',dob='$dob',Age='$age',Sex='$sex',Caste='$caste',dept='$dept', SSC%=$ssc , HSC%=$hsc, ATKTs=$atkt, Last_sem%=$lastsem, Aggregate%=$agg WHERE student_id=$id  ; ";

Some column names have a '%' sign in it. Mysql throws the following error when I execute it

Cannot execute.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 '%=79.6 , HSC%=81.83, ATKTs=5, Last_sem%=52.35, Aggregate%=53.6 WHERE student_id=' at line 1

Can't figure out the problem I have tried "\" , "#" , "%%" as escape characters but can't figure it out.

Kavi Siegel · Accepted Answer · 2012-02-16 17:34:17Z

2

Wrap it in backticks to tell SQL that it's a column, does this work?

$query = "UPDATE student_database SET fname='$fname',mname='$mname',lname='$lname',dob='$dob',Age='$age',Sex='$sex',Caste='$caste',dept='$dept', `SSC%`=$ssc , `HSC%`=$hsc, ATKTs=$atkt, `Last_sem%`=$lastsem, `Aggregate%`=$agg WHERE student_id=$id  ; ";

answered Feb 16, 2012 at 17:34

Kavi Siegel

2,9942 gold badges26 silver badges33 bronze badges

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

2 Comments

Jonah Over a year ago

Thank you KAVISIEGEL that helped. Can you please explain what the problem was?

Kavi Siegel Over a year ago

In MySQL queries, in order to say that something is a column, it can be wrapped in backticks. Note how in the code above, it says `SSC%` where in your code, it says SSC%

Mark Baker · Accepted Answer · 2012-02-16 17:34:49Z

1

Try wrapping the column names in backticks, e.g

`SSC%`=$ssc

answered Feb 16, 2012 at 17:34

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

Mysql query with a column name having '%' sign in it not executing in PHP

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related