Parse Error

[webnoob]

Im getting a nasty parse error on my code

if ($_POST['Submit'] == TRUE)
{
    $FixedPrice = '99';
    $ProductName = $_POST['ProductName'];
    $Finish = $_POST['Finish'];
    $Size = $_POST['Size'];
    $Price = $_POST['Price'];
    $Quantity = $_POST['Quantity'];
    
    $Connect = mysql_connect('localhost', 'glenn', '********') or die(myql_error);
    
    mysql_select_db('shadesofjapan', $Connect);

//The line below is the error line

    $Result = mysql_query("INSERT INTO shoppinglist (ProductName, Finish, Size, Price, Quantity, UserId) VALUES ('$ProductName', '$Finish', '$Size', '$Price', '$Quantity', '$_SESSION['UserId']')");
    
    if ($Result == TRUE)
    {
        ?>
        <script type="text/javascript">
        alert("Item added to shopping list")
        </script>
        <?
    }
    
    else
    {    
        ?>
        <script type="text/javascript">
        alert("Failed!")
        </script>
        <?
    }


}

?>

I know its something to do with the session variable being in there but im not sure hopw to correct it.

Thanks in advance

[lilleman]

Hi,

You have to enclose the session variable with curly brackets:

$Result = mysql_query("INSERT INTO shoppinglist (ProductName, Finish, Size, Price, Quantity, UserId) VALUES ('$ProductName', '$Finish', '$Size', '$Price', '$Quantity', '{$_SESSION['UserId']}')"); 

[webnoob]

worked a treat, thanks