UPDATE variable problem? 1

[dle46163]

I'm having a problem with the UPDATE command as it pertains to a MySQL database.

My query code is this:

$query_fee = "UPDATE customer_contacts SET '{$_SESSION['type']}' = '{$_POST['amount']}'
WHERE Company_Name = '{$_SESSION['comp_name']}'";


The problem is after the SET command, I need the field I'm setting to be a variable earlier defined. If I echo the $_SESSION['type'] before I execute the query the data looks correct. However, when I run the query I get a bad query return. I can also replace the variable with the actual name of the field and it works. But I need it to be dynamic. Any thoughts?

 

[ericbrunson]

Take the $_SESSION[] out of the quotes.

 

[ericbrunson]

Wrong button, sorry.

PHP does not properly interpret array variable expansion in double quotes. You'll either have to assign the array elements to scalars, or take them out of the quotes and concatenate the strings to get the sql string.

$string = "update tab set col = '" . $_SESSION[ 'var' ] . "'";

 

[vbkris]

$query_fee = "UPDATE customer_contacts SET '{".$_SESSION['type']."}' = '{".$_POST['amount']."}'
WHERE Company_Name = '{".$_SESSION['comp_name']."}'";


one more thing:
why the use of {}???

Known is handfull, Unknown is worldfull

 

[predamarcel]

hi,
you should remove the "simple quote" from '{$_SESSION['type']}', like:

$query_fee = "UPDATE customer_contacts SET {$_SESSION['type']} = '{$_POST['amount']}'
  WHERE Company_Name = '{$_SESSION['comp_name']}'";

___

http://marcel.4x4.ro/

____