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;
?>