Help: Code worked but stoped working??

[CoderJohan]

I have a problem... I was working on a replay form... ppl send in questions and i replay using
<textarea name=\"svarat_$i\" cols=\"50\" rows=\"8\" class=\"bigbox\">

why the name svarat$i is because i wanna awnser many questions at the same time... Here is my problem... The code did work great but for somehow it all stoped working and i can't figure out whats wrong? Here is the update string
mysql_query("UPDATE fspaltsvar SET spara=".$var["jn$i"].", svar=".$var["svarat$i"]." WHERE id=".$var["jnid$i"]."");

spara gets a value of 0,1 or 2 depending on what i wanna do with the post... If i take away , svar=".$var["svarat$i"]." it works fine... spara gets its new number but with the , svar=".$var["svarat$i"]." in the code nothing happends and i can't figure out whats wrong... and whats even more annoying is that the code worked i updated 3 questing the same time and it got posted but now it has stoped working... Does anyone know what problem it is?

//Johan

[cgraz]

not sure exactly what the problem is, I've never used dollar signs inside my variable names, but i'd try printing the query and also using mysql_error.

$query = "UPDATE fspaltsvar SET spara=".$var["jn_$i"].", svar=".$var["svarat_$i"]." WHERE id=".$var["jnid_$i"].""; 
print $query . "<br>";

$result = mysql_query($query) or die(mysql_error());

That should help you get to the problem easily.

Cgraz

[CoderJohan]

This is the error i get... I can't figure out whats the problem... it's the first time i'm using this code so 🙂

UPDATE fspaltsvar SET spara=1, svar=dsdsdsds WHERE id=1
Unknown column 'dsdsdsds' in 'field list'

[xblue]

All strings mysql receives must be singlequoted. Change it to this:

"UPDATE fspaltsvar SET spara=".$var["jn_$i"].", svar='".$var["svarat_$i"]."' WHERE id=".$var["jnid_$i"]

[CoderJohan]

Yes it works! Strange that it did work before when i used " " thats strange.... Anyway Thanks alot 🙂
//Johan