SQL语句问题,很奇怪呀!大家来瞧瞧! 是不是你的ODBC配置的不对呀? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我想应该不会吧?我把这句话改成这样:$sql = "SELECT building_table.*,floor_table.* FROM building_table , floor_table";又可以。估计跟配置关系不大,有没有可能是ACCESS数据库的SQL语法不一样造成的?但我想,通过ADODB联接应该不存在这种问题的呀! <?php// ADO操作Access2000include('../adodb/adodb.inc.php'); $conn = ADONewConnection('access');$dbf = "C:\MYWEB\\Door\\Database\\door.mdb";$dsn = "Driver={Microsoft Access Driver (*.mdb)};". "Dbq=$dbf;Uid=;Pwd=;";$dbf = "C:\\MYWEB\\Door\\Database\\door.mdb";$conn->Connect($dsn);/*$sql = "SELECT b.BUILD_NAME,f.FLOOR_NAME FROM " . building_table . " b, ". floor_table ." f WHERE b.ID = f.ID ORDER BY b.ID,f.ID";*/$sql = "SELECT building_table.BUILD_NAME,floor_table.FLOOR_NAME FROM building_table , floor_table WHERE building_table.ID = floor_table.BUILD_ID ORDER BY building_table.ID,floor_table.ID";$recordSet = &$conn->Execute($sql);echo $sql;if (!$recordSet) print $conn->ErrorMsg();else while (!$recordSet->EOF) { for ($i=0;$i<$recordSet->FieldCount();$i++) print $recordSet->fields[$i].' '; print "<br/>"; $recordSet->MoveNext(); }$recordSet->Close(); $conn->Close(); ?> 估计是sql语法问题,ACCESS跟MYSQL的sql语句还是有一点区别的。 如果$sql = "SELECT building_table.*,floor_table.* FROM building_table , floor_table";可以而$sql = "SELECT building_table.BUILD_NAME,floor_table.FLOOR_NAME FROM building_table , floor_table WHERE building_table.ID = floor_table.BUILD_ID ORDER BY building_table.ID,floor_table.ID";不可以那么请检查所涉及的字段名在对应的表中是否存在 是recordset.open还是conn.execute???? 如果$sql = "SELECT building_table.*,floor_table.* FROM building_table , floor_table";可以而$sql = "SELECT building_table.BUILD_NAME,floor_table.FLOOR_NAME FROM building_table , floor_table WHERE building_table.ID = floor_table.BUILD_ID ORDER BY building_table.ID,floor_table.ID";不可以那么请检查所涉及的字段名在对应的表中是否存在根本存在,如果不存在的话,提示信息都不一样。 无法获取超链接 php文件里加视频显示不出来 在POST或者GET中,很多程序都用if()elseif()判断? 请教诸位phper 关于form表单提交的问题(在线等) 网页上被注入恶意代码如何解决?急!! 该继续找PHP的工作做还是和朋友一起创业? 如何将图片上传到数据库,或者上传图片路径到数据库。不够再加分。在线等! 问一SQL查询 如何在mysql中读出二进制的文件内容 php.ini修改出错,.. 请问php有什么函数可以把swf文件转换成jpg吗? HELP~~~~~ HELP~~~~~~~~~
$sql = "SELECT building_table.*,floor_table.*
FROM building_table , floor_table";
又可以。
估计跟配置关系不大,有没有可能是ACCESS数据库的SQL语法不一样造成的?但我想,通过ADODB联接应该不存在这种问题的呀!
include('../adodb/adodb.inc.php');
$conn = ADONewConnection('access');
$dbf = "C:\MYWEB\\Door\\Database\\door.mdb";
$dsn = "Driver={Microsoft Access Driver (*.mdb)};".
"Dbq=$dbf;Uid=;Pwd=;";
$dbf = "C:\\MYWEB\\Door\\Database\\door.mdb";
$conn->Connect($dsn);/*$sql = "SELECT b.BUILD_NAME,f.FLOOR_NAME
FROM " . building_table . " b, ". floor_table ." f
WHERE b.ID = f.ID ORDER BY b.ID,f.ID";*/$sql = "SELECT building_table.BUILD_NAME,floor_table.FLOOR_NAME
FROM building_table , floor_table
WHERE building_table.ID = floor_table.BUILD_ID ORDER BY building_table.ID,floor_table.ID";$recordSet = &$conn->Execute($sql);
echo $sql;
if (!$recordSet)
print $conn->ErrorMsg();
else
while (!$recordSet->EOF)
{
for ($i=0;$i<$recordSet->FieldCount();$i++)
print $recordSet->fields[$i].' ';
print "<br/>";
$recordSet->MoveNext();
}$recordSet->Close();
$conn->Close();
?>
$sql = "SELECT building_table.*,floor_table.*
FROM building_table , floor_table";
可以
而
$sql = "SELECT building_table.BUILD_NAME,floor_table.FLOOR_NAME
FROM building_table , floor_table
WHERE building_table.ID = floor_table.BUILD_ID
ORDER BY building_table.ID,floor_table.ID";
不可以
那么请检查所涉及的字段名在对应的表中是否存在
$sql = "SELECT building_table.*,floor_table.*
FROM building_table , floor_table";
可以
而
$sql = "SELECT building_table.BUILD_NAME,floor_table.FLOOR_NAME
FROM building_table , floor_table
WHERE building_table.ID = floor_table.BUILD_ID
ORDER BY building_table.ID,floor_table.ID";
不可以
那么请检查所涉及的字段名在对应的表中是否存在根本存在,如果不存在的话,提示信息都不一样。