php挑选出重复值,PHP代码：从数据表里塞选出重复的数据_php

mysql_connect('localhost','','');   //添加相应的mysql主机名，用户名，密码

mysql_select_db('');           //添加相应的mysql的数据库名

$sql = "SELECT * FROM ''";       //添加相应的数据表的名字

$query = mysql_query($sql);

$i = 0;

http://www.gaodaima.com/47893.htmlPHP代码：从数据表里塞选出重复的数据_php

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》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~