为MySQL查询连接和插入PHP变量

Question

I have 3 variables that contain a text string. I need to update them in the table, but out of the 20+ different variations of about 5 different scripts that I've tried out, it just doesn't update! I want something like below script:

mysql_query("UPDATE $variable_1 SET $variable_2 = $q WHERE $variable_3 = $o")
   or die(mysql_error());

Answer 1

Try this code:

mysql_query("UPDATE table_name SET field_name = '"
    .$str_value."' WHERE $field_3 = '".$str_value.'")
  or die(mysql_error());