How to fix an unexpected quote in sql update

Question

I got an error of unexpected " in the code shown below

Tried to sum columns and then update each row in a SUM-Cell as I run the code.

$QQ = "UPDATE T_IMB19 SET SUM1=$SUMA, SUM2=$SUMB, TOTAL=$SUMTOT WHERE Navn=$rows['Navn']";
mysqli_query($con,$QQ);

I have echo on the SUMA, SUMB and SUMTOT and they act nicely, but the update doesn't work.

Error : "Parse error: syntax error, unexpected '' (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING)"

Don't write SQL like that. Also this is a PHP error, not SQL. SQL should be, `UPDATE T_IMB19 SET SUM1=?, SUM2=?, TOTAL=? WHERE Navn=?`. — user3783243, Oct 27 '19 at 13:41
... or https://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php — user3783243, Oct 27 '19 at 13:41

score 0 · Answer 1 · edited Oct 27 '19 at 13:42

0

just add double quotes again for each after and before single quotes, and then join it with . like below code.

$QQ = "UPDATE T_IMB19 SET SUM1=$SUMA, SUM2=$SUMB, TOTAL=$SUMTOT WHERE Navn='" . $rows['Navn'] . "'";
mysqli_query($con,$QQ);

edited Oct 27 '19 at 13:42

user3783243

5,368
5
22
41

answered Oct 27 '19 at 13:37

meotig

76
5

score 0 · Answer 2 · answered Oct 27 '19 at 13:43

0

You don't need the single quotes for the array key when you're within a string.

$QQ = "UPDATE T_IMB19 SET SUM1=$SUMA, SUM2=$SUMB, TOTAL=$SUMTOT WHERE Navn='$rows[Navn]'";
mysqli_query($con,$QQ);

On a side note you may want to use PDO for making your life easier for SQL queries. More docs about it here

answered Oct 27 '19 at 13:43

rowen5

1

This works. Thanks for helping comment. :-) – Karsten Iversen Oct 28 '19 at 14:17

How to fix an unexpected quote in sql update

2 Answers2