php4.3+sql sever问题
我的网址:http://mumushu.126.com
我要插入数据库内容中有这样一段代码
function TCart()
{
$this->SortCount = 0;
session_start(); //初始化一个session
session_register('sId');
session_register('sName');
session_register('sPrice');
session_register('sDiscount');
session_register('sGoodPrice') ;
session_register('sCount') ;
session_register('sMaxCount') ;
$this->Update();
$this->Calculate();
}
//********私有,根据session的值更新类中相应数据
function Update()
{
global $_SESSION['sId'],$_SESSION['sName'],$_SESSION['sPirce'],$_SESSION['sDiscount'];
//$_SESSION['sGoodPrice'],$_SESSION['sCount'],$_SESSION['sMaxCount'];
//global $sId,$sName,$sPrice,$sCount,$sDiscount,$sMaxCount,$sGoodPrice;
if(!isset($_SESSION['sId']) or !isset($_SESSION['sName']) or !isset($_SESSION['sPrice'])
or !isset($_SESSION['sDiscount']) or !isset($_SESSION['sMaxCount'])
or !isset($_SESSION['sGoodPrice']) or !isset($_SESSION['sCount']))
return;
$this->Id = $_SESSION['sId'];
$this->Name = $_SESSION['sName'];
$this->Price = $_SESSION['sPrice'];
$this->Count = $_SESSION['sCount'];
$this->Discount = $_SESSION['sDiscount'] ;
$this->GoodPrice = $_SESSION['sGoodPrice'] ;
$this->MaxCount = $_SESSION['sCount'] ;
//计算商品总数
$this->SortCount = count($_SESSION['sId']);
}
//********私有,根据新的数据计算每类商品的价值及全部商品的总价
function Calculate()
{
for($i=0;$i<$this->SortCount;$i++)
{
/*计算每件商品的价值,如果折扣是0 ,则为优惠价格*/
$GiftPrice = ($this->Discount[$i] == 0 ? $this->GoodPrice :
ceil($this->Price[$i] * $this->Discount[$i])/100 );
$this->TotalCost += $GiftPrice * $this->Count[$i] ;
}
}
报错为:
Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near 'sId'. (severity 15) in D:\hondream\mmshu\article\insert.php on line 18
Warning: mssql_query() [function.mssql-query]: Query failed in D:\hondream\mmshu\article\insert.php on line 18
这是什么原因呢,以前的版本还好啦!请各位回帖。谢谢啦