我使用下面的方法还是得到0条记录,难道是ADODB的Execute方法有问题? $vRecordSet = $vConn->Execute($vSQL);
$vCNT = 0;
$vRecordSet->MoveFirst();
while (! $vRecordSet->EOF)
{
$vCNT += 1;
$vRecordSet->MoveNext();
}
$vRecordSet->Close();
$vConn->Close();
echo $vCNT;
$vCNT = 0;
$vRecordSet->MoveFirst();
while (! $vRecordSet->EOF)
{
$vCNT += 1;
$vRecordSet->MoveNext();
}
$vRecordSet->Close();
$vConn->Close();
echo $vCNT;
CREATE TABLE t_user
(
F_ID INT(10) NOT NULL AUTO_INCREMENT, /* 自动增量 */
F_No CHAR(20) NOT NULL, /* 编号 */
F_Name VARCHAR(50) NOT NULL, /* 姓名 */
PRIMARY KEY(F_ID), KEY(F_No)
);
INSERT INTO t_user(F_No, F_Name, F_Password) VALUES('admin', 'Admin', PASSWORD('admin'));难道没有问题吗????
请问F_Password字段是哪来的???
表里面根本没有
$vConn = &NewADOConnection('mysql');
$vConn->PConnect(DB_Host, DB_User, DB_Password, DB_Database);
$admin = $vConn->qstr('admin');
$pass = $vConn->qstr('admin');
$vSQL = "SELECT F_No FROM t_user WHERE (F_No=$admin) AND (F_Password=PASSWORD($pass))";
$vRecordSet = $vConn->Execute($vSQL);
F_Password CHAR(16) binary NOT NULL, /* 密码 */
然后把Execute换成ExeCute看看