<?php
mysql_connect(‘localhost’,”,”); //添加相应的mysql主机名，用户名，密码
mysql_select_db(”); //添加相应的mysql的数据库名
sql = “SELECT * FROM ””; //添加相应的数据表的名字
query = mysql_query(sql);
i = 0;
while(result = mysql_fetch_array(query))
{
sqlstr = “select * from smsorderinfo where ordermobile = ‘”.result[\'ordermobile\'].”‘ and itemkind = ‘”.result[\'itemkind\'].”‘”;
//echo “ordermobile = “.result[\'ordermobile\'].” itemkind = “.result[\'itemkind\'].”\\n”;
//echo “sqlstr = “.sqlstr.”\\n”;
if (query1 = mysql_query(sqlstr))
{
//echo “成功\\n”;
while (result1 = mysql_fetch_array(query1))
{
if (result[\'id\'] != result1[\'id\'])
{
echo “发现重复: id1 = “.result[\'id\'].” id2 = “.result1[\'id\'].”\\n”;
//else echo “######################: id1 = “.result[\'id\'].” id2 = “.result1[\'id\'].”\\n”;
sqlstr2 = “delete FROM smsorderinfo WHERE id = ‘”.result[\'id\'].”‘”;
//echo sqlstr2;
if(mysql_query(sqlstr2))
{
echo “删除成功!\\n”;
}
else
echo “删除失败!”;
}
}
}
//arry[] = result[\'ordermobile\'].result[\'itemkind\'];
//echo result[\'zuhe\'].”<br>”;
i++;
}
echo i;
?>
\n
来源:网络
\n