$conn=mssql_connect('localhost','sa','123');
$conn1=mssql_connect('localhost','sa','123');
mssql_select_db('QPGameUserDB',$conn1);
mssql_select_db('QPTreasureDB',$conn);
$sql1="select * from AccountsInfo ";
$sql2="select * from GameScoreInfo ";
$rest1=mssql_query($sql1);
$rest2=mssql_query($sql2);
$num=mssql_fetch_array($rest1);
$Row=mssql_fetch_array($rest2);
print_r($Row);
print_r($num);
连接不到
错误提示
Warning: mssql_query() [function.mssql-query]: message: 对象名 'AccountsInfo' 无效。 (severity 16) in D:\xampp\htdocs\1.php on line 63Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampp\htdocs\1.php on line 63
$rest2=mssql_query($sql2,$conn1);
如select * from 库名.表名
多表连接 select * from 库1.table1 as A left join 库2.table as B on A.id= B.id
另外先在phpmyadmin中执行一下你的sql语句,看是不是对的.
$sql1="select * from AccountsInfo ";
$rest1=mssql_query($sql1);mssql_select_db('QPTreasureDB',$conn);
$sql2="select * from GameScoreInfo ";
$rest2=mssql_query($sql2);
改成mssql_select_db('QPGameUserDB',$conn);
请看http://www.nayitian.com/2009/06/php_functions-mysql_connect/
$conn1=mssql_connect('localhost','sa','123','new_link ');
$conn2=mssql_connect('localhost','sa','123','new_link ');
mssql_select_db('QPGameUserDB',$conn1);
mssql_select_db('QPTreasureDB',$conn2);
$sql1="select * from AccountsInfo ";
$sql2="select * from GameScoreInfo ";
$rest1=mssql_query($sql1,$conn1);
$rest2=mssql_query($sql2,$conn2);
$num=mssql_fetch_array($rest1);
$Row=mssql_fetch_array($rest2);
print_r($Row);
print_r($num);
我遇到同样问题,通过类创建的 mssql_connect 多个连接,莫名其妙混到其一起了。
兄弟在么,有联系方式么?