如何在此查询中使用 DISTINCT 子句以消除重复结果 - How do i use a DISTINCT clause with this query in order to eliminate duplicate results?

How do i use a DISTINCT clause with this query in order to eliminate duplicate results?

本文关键字：子句结果 DISTINCT 查询 | 更新日期: 2023-09-27

<?php 
  $k = $_GET['K'];
  $terms = explode(" ", $k);
  $query = "SELECT * FROM search WHERE ";
  foreach ( $terms as $each) {
          $i++;
      if($i == 1)
      $query .= "keywords LIKE '%$each%' ";
      else
        $query .= "OR keywords LIKE '%$each%' ";

}

要求（"连接.php"）;

$query = mysql_query（$query）;

$numrows = mysql_num_rows（$query）;

if（$numrows> 0）{

而（$rows = mysql_fetch_assoc（$query））{

        $id = $rows['id'];
        $title = $rows['title'];
        $description = $rows['descriptions'];
        $keywords = $rows['keywords'];
        $link = $rows['link'];

        echo "<h2><a href = '$link'> $title </a></h2> 
        $description <br /> <br />";

}

}else

echo "未找到 ''"$k"的结果;

mysql_close（）;

你可以这样做

$query = "SELECT DISTINCT *FROM search WHERE ";