$TableArray=array("items","players","pvp2","quests","recipes","skills","talents","talenttree","members");
$Sql="select * from players where member_id=".$MemberID;
$Rs=$SubConn->Execute($Sql);
if ($Rs){
if ($Rs->RecordCount()<1){
$WhereStr=" member_id=".$MemberID;
$Message="";
foreach($TableArray as $TableName){
$Message.= BackupDataBase($MainConn,$SubConn,$TableName,$WhereStr,"REPLACE");
}
}else{
$Message="<br>记录已经存在,此次执行跳过!";
}
}else{
echo $SubConn->ErrorMsg();
}
$SubConn->Close();我的调用方法。
$Sql="select * from players where member_id=".$MemberID;
$Rs=$SubConn->Execute($Sql);
if ($Rs){
if ($Rs->RecordCount()<1){
$WhereStr=" member_id=".$MemberID;
$Message="";
foreach($TableArray as $TableName){
$Message.= BackupDataBase($MainConn,$SubConn,$TableName,$WhereStr,"REPLACE");
}
}else{
$Message="<br>记录已经存在,此次执行跳过!";
}
}else{
echo $SubConn->ErrorMsg();
}
$SubConn->Close();我的调用方法。
http://blog.csdn.net/julychina/archive/2006/03/17/627367.aspx