Question

如何在php中用ODBC函数读取数据库里的一条结果集

我用的是odbc连接的数据库，只想从数据库里读取一条结果集，拜托众位高手了啊！

Answer 1

以下是用odbc连接数据库的例子：

<?php
$db_connection = new COM("ADODB.Connection");
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\DataDir\Employee.mdb;DefaultDir=C:\DataDir";

$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT EmpNameLocal, EmpPosLocal FROM tbl_Employee WHERE ID='$IDNo'");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
$empNameLoc = $rs_fld0->value;
$empWPPos = $rs_fld1->value;
$rs->MoveNext();
}

$rs->Close();
$db_connection->Close();
?>

Answer 2

使用where条件。select * from tablename where id='xx';他得出来的结果就是一条结果集？是这样吗