PHP代碼：從資料表裡塞選出重複的資料

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