PHP-MySQL UPDATE with joined variable and string

[ooda55]

Hi there,

is it possible to join a variable and a string inside a $_POST variable inside a mysql query (UPDATE in this case)

 

Here is what i am trying to accomplish:

$update = "UPDATE mona SET STKFF='$_POST[$counter."NAME"]' WHERE id='$userid'";

if (!mysql_query($update))
  {
  die('Error: ' . mysql_error());
  }
else echo " <br> Update Complete";

Its the

'$_POST[$counter."NAME"]'

bit that im worried about, is this possible without having to do:

$foo=$counter."NAME"
'$_POST[$foo]'

 

Thanks

Chris

[PFMaBiSmAd]

$update = "UPDATE mona SET STKFF='{$_POST[$counter."NAME"]}' WHERE id='$userid'";