显示相同内容的搜索结果[关闭]

Question

I have a search bar and a sql database with 3 movies in

Name:Star Wars: Description: Contains the word group
Name:301: Description: Contains the word group
Name:destroyer: Description: Contains the word group

BUT when ever I search for the word "group"

I only get one result usually:

if i search for group star wars will appear 3 time.

also i know its vulnerable to sql injection but at the moment that is not an issue

here is my php code:

 if(!isset($_POST['search']))
 {
   header("Location:index.php");

 }

$search_sql="SELECT * FROM php_item WHERE Name LIKE '%".$_POST['search']."%' OR Description LIKE '%".$_POST['search']."%'";
$search_query = mysql_query($search_sql);
 if(mysql_num_rows($search_query)!=0)
 {

   $search_rs= mysql_fetch_assoc($search_query);
  }


 ?>


      </p>
      <p>&nbsp; Search Results</p>
      <?php

       if(mysql_num_rows($search_query) != 0){
          do{ ?>

          <p>
          <?php echo $search_rs['Name']; ?>

         <?php     }while($searchr_rs=mysql_fetch_assoc($search_query));

      } else {
        echo "No Results Found";  
      }
      ?>

Answer 1

If this is your code, there is a typo in the while. It should be $search_rs=mysql_fetch_assoc($search_query). You have an extra 'r'.

Good Luck!