为什么字符串一旦经过赋值，数据库语句就认不出来了

divtian 发布于 2015-09-28 08:58， 1974 次点击

<?

$conn=@mssql_connect("MDMQBJPPC43VP31","sa","12345");

mssql_select_db("huanban",$conn);
$a='a';

$rs3=mssql_query("select *  from ceshi where ceshi=$a   ",$conn);
while($row3=mssql_fetch_array($rs3))
{

echo $row3[0] ;

}

?>

为什么这样不行？  如果把$a直接换成'a'就可以呢？

1 回复

divtian2015-09-28 09:06

Warning: mssql_query() [function.mssql-query]: message: �� 'a' ��Ч�� (severity 16) in D:\PHPnow-1.5.6\htdocs\123.php on line 8

Warning: mssql_query() [function.mssql-query]: Query failed in D:\PHPnow-1.5.6\htdocs\123.php on line 8

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in D:\PHPnow-1.5.6\htdocs\123.php on line 9

报错是这样的，好像字符串赋值出了问题。