mysql UPDATE weird problem

[kuwalda]

I have query which looks like this:

local update = mysql_query(handler,"UPDATE cars SET engine = '"..upgrade.."' WHERE car_model = '"..getElementModel(getPedOccupiedVehicle(thePlayer)).."' and car_numberplate= '"..getVehiclePlateText(getPedOccupiedVehicle(thePlayer)).."' and car_owner = '"..getPlayerName(thePlayer).."';") 

Focus here is on SET engine = '"..upgrade.."', because it works fine like this, but when I try to set variable instead of engine, it stops working. Why?

Tried like this:

mysql_query(handler,"UPDATE cars SET '"..upgradojamais.."' = '"..upgrade.."' ... 
  
 

and like this:

mysql_query(handler,"UPDATE cars SET '"..tostring(upgradojamais).."' = '"..upgrade.."' ... 
  
 

,but none of them worked? Why?

Variable "upgradojamais" is fine, I already checked on that. It is getting passed with function (second variable)

setCarDBdata(source, "engine", upgrade) 

[botder]

Use ` and not ' for the column (e. g. engine)

[kuwalda]

Thanks, it worked