Updating sql server using php is am using the following code and am getting an error



<?php require_once('mssqldbcon.php'); ?>
<?php
if(isset($_POST['status']))
{       
        $policyNumber=($_POST['policy']);
        $bso_id=($_SESSION['myid']);
        $bso_status=($_POST['status']);
        $reason=($_POST['reason']);
        $mgr_status=($_POST['mgr_status']);
       
   
        $query = "update new_policies set bso_id = $bso_id, bso_status =$bso_status, Decision_bso=$reason, bso_date = GETDATE()
        where Policy_Number = $policyNumber";
       
         echo $query;
       
        $result = mssql_query($query);
        $info = "<div class=\"message\">Proposals Submitted Successful</div>";
  
}
else{
         $info = " Submisson error";
}
?>



--

This is the error I get
It is our light, not our darkness, that frightens us.


Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ','. (severity 15) in C:\xampp\htdocs\newbusiness\checkConfirm.php on line 37

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\newbusiness\checkConfirm.php on line 37






I will much appreciate help or idea


Calvin Omari Systems Developer/Designer
http://www.facebook.com/barongo