[Skunkworks] updating SQL Server using php script

5 Aug 2010

      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.

Theme*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