Using UPDATE

[sierra23]

I have a db and I want to update one contens i it. I have try this
$sql = 'UPDATE romdb SET status = \'opptatt\','
. ' alt = NULL WHERE rid = \'1\' LIMIT 1 ;'
. ' ';

this is working, but I want to use a variable like $brid insteed of \'1\'

Can enyone help me???

[Mordecai]

Use the concat operator, a period:

echo 'this is some string with a '.$variable.' in the middle';

[yelvington]

Or read the section of the manual that explains how variables are expanded inside double-quoted strings,