$sqlstr ='SELECT ID,pid,sname,';
$sqlstr.='(SELECT count(ID) FROM yh_wsort WHERE (pid=A.id)) as nss ';
$sqlstr.='FROM yh_wsort A ';
$sql_yh.='WHERE (pid=0) ';
上面这个是在PHP中查询MYSQL的语句,不能运行,这是从MSSQL那边转过来的,请教,这样的子查询语法在MYSQL中怎么写?
$sqlstr.='(SELECT count(ID) FROM yh_wsort WHERE (pid=A.id)) as nss ';
$sqlstr.='FROM yh_wsort A ';
$sql_yh.='WHERE (pid=0) ';
上面这个是在PHP中查询MYSQL的语句,不能运行,这是从MSSQL那边转过来的,请教,这样的子查询语法在MYSQL中怎么写?
$sqlstr.='(SELECT count(ID) FROM yh_wsort WHERE (pid=A.id)) as nss ';
$sqlstr.='FROM yh_wsort A ';
$sql_yh.='WHERE (pid=0) ';你的PHP代码对吗?
错误信息是什么?
$sqlstr ='SELECT `ID`,pid,sname,';
$sqlstr.='(SELECT count(`ID`) FROM yh_wsort WHERE pid=A.`id`) as nss ';
$sqlstr.='FROM yh_wsort A ';
$sql_yh.='WHERE (pid=0) ';
后面怎么有个$sql_yh