Question

[php]这个SQL语句错误是怎么回事

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '有错误' at line 3

$html=new html('time',"month",$rootpath."/html");//实例化HTML类
$sql="select a.guestprice,a.memberprice,a.sname,
b.name,b.model,b.simage,b.bimage,b.made,b.brand,b.proid,b.code,b.introduce,b.id,b.bigclassid,b.smallclassid,b.bigfunid,b.smallfunid
from t_area_product a,t_product b where a.proid=b.proid and b.Id=$pid";
$query = $DB->query ( $sql."有错误" );
foreach($query as $val){

Answer 1

$query = $DB->query($sql);
你的sql语句最后还跟一段有中文的，太……
报错说：语法错误，错误在 “有错误”附近。

Answer 2

$query = $DB->query ( $sql."有错误" );
改为
$query = $DB->query ( $sql);