$rs = @new COM("ADODB.RecordSet");
$sql="Select * From Online Where LoginName ='".$LoginName."'";
$rs->open($sql,$conn,1,3);
改成:$sql="Select * From Online Where LoginName ='".$LoginName."'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {//读你的数据}
$sql="Select * From Online Where LoginName ='".$LoginName."'";
$rs->open($sql,$conn,1,3);
改成:$sql="Select * From Online Where LoginName ='".$LoginName."'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {//读你的数据}
$r1=mysql_fetch_array($result);
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb"); $result = mysql_query("SELECT id, name FROM mytable"); while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf ("ID: %s Name: %s", $row[0], $row[1]);
} mysql_free_result($result);
?>
给你个读数据的例子。
最好的办法是
1 将access数据库结构和数据转换成mysql
2 按照访问access的方法,封装mysql的类,使它和access访问的时候保持一致.
9494更改数据库,不仅仅是连接的问题,里面还有SQL的兼容问题。