你好,你能帮我一下吗,我不知道我的错误在哪里。下面是我的代码:
$capacitance =@mysql_query ("SELECT DISTINCT wwpn, SUBSTR(val, 1, LENGTH(val) / 2) as capacitor,
SUBSTR(val, LENGTH(val) / 2+1) as capasitance
FROM bom_csv where boardnumber ='$board' and qty<>'' and qty !='qty'");
@mysql_query($capacitance,$connect)or die("Failed to execute query:<br />" . mysql_error(). "<br />" . mysql_errno());
while($row = mysql_fetch_array($capacitance))
{
$capacitor = $row['capacitor'];
$capacitance =$row['capasitance'];
$adi_pn = $row['wwpn'];
}
和错误,当我执行它的php:
Failed to execute query:
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 'Resource id #4' at line 1
1064
您的第一个mysql_query
正在返回一个资源(结果集)并将其分配给$capacitance
。当您在下一行再次执行mysql_query
时,$capacitance
,一个资源,被转换为字符串- "Resource #4"
,可能-这不是一个正确的SQL。
还要注意"Bobby Tables doesn't go to my school"不一定是真的:正确转义字符串
$capacitance = @mysql_query ("SELECT DISTINCT wwpn, SUBSTR(val, 1, LENGTH(val) / 2) as capacitor,
SUBSTR(val, LENGTH(val) / 2+1) as capasitance
FROM bom_csv where boardnumber ='" . mysql_real_escape_string($board) . "' and qty<>'' and qty !='qty'", $connect)
or die("Failed to execute query:<br />" . mysql_error(). "<br />" . mysql_errno());
while ...