Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/10 6:47:01
PHP代码：从数据表里塞选出重复的数据_[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']."
";
i++;
}
echo i;
?>

来源:网络

赞