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’].”<br>”;
  $i++;
  }
  echo $i;
?>

欢迎大家阅读《PHP代码：从数据表里塞选出重复的数据_php》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

喜欢 (0)赏

[搞代码]

分享 (0)