mysql unexpected if_连接mysql时unexpected T_ENCAPSED_AND_WHITESPACE错误

$m_dblink=mysql_connect(“xxx”,”user”,”passwore”,true)or die(‘Could not connect database in host’);

mysql_select_db(“check”,$m_dblink) or die(‘Could not select database’);

mysql_query(“SET NAMES UTF8”,$m_dblink);

$query=”SELECT a.qa,a.svn_url,a.notifylist,b.tablename,b.file,b.level,b.description FROM result as b,svnurl_check_list AS a WHERE a.line=”search” and a.line = b.line

and b.result=”fail”;

echo $query,PHP_EOL;

$result = mysql_query($query,$m_dblink) or die(‘uery failed:’ );

$count = mysql_num_rows($result);

for($index=0; $index < $count; $index++){

$row = mysql_fetch_array($result, MYSQL_ASSOC);

//$tablename= $row[‘tablename’];//这就是出错的那行

print_r($row);

//echo ” tablename:$tablename”;

}

mysql_free_result($result);

mysql_close($m_dblink);

报了下面的错误:

PHP Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in line 36

但出错的那行是注释掉了的呀

原因到底在哪里呢

回复讨论(解决方案)

$query=”SELECT a.qa,a.svn_url,a.notifylist,b.tablename,b.file,b.level,b.description FROM result as b,svnurl_check_list AS a WHERE a.line=”search” and a.line = b.line

and b.result=”fail””;

问题在这里

$query=”SELECT a.qa,a.svn_url,a.notifylist,b.tablename,b.file,b.level,b.description FROM result as b,svnurl_check_list AS a WHERE a.line=”search” and a.line = b.line

and b.result= “fail”;

应写作

$query=”SELECT a.qa,a.svn_url,a.notifylist,b.tablename,b.file,b.level,b.description FROM result as b,svnurl_check_list AS a WHERE a.line=”search” and a.line = b.line

and b.result= ‘fail'”;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值