Newbie - MySql string and variables

[deleonbe]

Hello,

I'm a newbie to PHP/MySQL. I'm able to take a string in php add a variable somewhere and get the result. ($testres = "This is a test $variable"😉

My question is, if I have a field in MySQL and I type in that field "This is a test $variable," how do/can I have PHP replace $variable with the proper info?

Any suggestions will be appreciated.

[appel]

Use $testres = "This is a test ".$variable; right before you do the INSERT/UPDATE. PHP should take care of it, provided that the $variable contains a value.