Table that updates database? (Code shown)

[leo7068]

Please help me troubleshoot this code which gives a Parse error:

 

<?
if (isset($_POST['submit']))
{
$UpdateQueryonSubmit="UPDATE QA SET room_number = '{$_POST['room_number']}', TV = '{$_POST['TV']}', TV_Date = '{$_POST['TV_Date']}', mWave = '{$_POST['mWave']}', mWave_Date = '{$_POST['mWave_Date']}' WHERE room_number= $_POST['roomID']";
mysql_query($UpdateQueryonSubmit);
}
?>

 

Gives this error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

 

referring to line:

 

room_number= $_POST['roomID']"

[jdavidbakr]

You're missing the curly braces around the $_POST['room_id']

[leo7068]

Thanks Jon,

 

That fixed it. Silly mistake on my part, and good to have a fresh set of eyes to spot it right away. Thanks.