PHP代码：从数据表里塞选出重复的数据
php中文网
发布： 2016-06-21 09:00:02
原创
1169人浏览过
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;
?>
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;
?>
相关标签：
PHP速学教程(入门到精通)
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
来源：php中文网
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
最新问题
11045
收藏
