How to correct this query

Question

It always Gives error

I have tried putting variables in quotes felids names in quotes but still error

"UPDATE employee_info
        SET NAME=$Name, ADDRESS=$Address, EMAIL=$Email, CELL_NO=$Cell_no, CNIC=$Cnic, DESIGNATION=$Designation, BASIC_PAY=$Basic_pay, BONOUS=$Bonous, TOTAL_PAY=$Basic_pay+$Bonous
        WHERE ID=$ID"))

Updated ROW

why there are two brackets at last? – M.Hemant Apr 19 '19 at 05:11 — M.Hemant, Apr 19 '19 at 05:11
post your error – Syed mohamed aladeen Apr 19 '19 at 05:14 — Syed mohamed aladeen, Apr 19 '19 at 05:14

score -1 · Accepted Answer · answered Apr 19 '19 at 05:27

Wrap text containing fields in quotes like-

"UPDATE employee_info SET NAME='$Name', ADDRESS='$Address', EMAIL='$Email', CELL_NO=$Cell_no, CNIC=$Cnic, DESIGNATION=$Designation, BASIC_PAY=$Basic_pay, BONOUS=$Bonous, TOTAL_PAY=$Basic_pay+$Bonous WHERE ID=$ID"

If there are more fields containing text then wrap them too.

How to correct this query

1 Answers1