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; ?> |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 13:19 , Processed in 0.115916 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.