Prevent search of same word twice

[Moezzie]

Im going totally crazy over this.
Im right now building a verry small solution for searching a mysql-database for up to five keywords.
Every file in the database has 2 or more keywords wich the searchengine compares its keywords to.

There is a great problem though, i get many results twise.
EXAMPLE:

Search for: cow and dog

"dog" will return all files with the keyword dog and so will cow with the keyword cow. But when a file contains both the keywords dog and cow it is going to be listed once for each of the searched words.

Sorry, i know it sounds a little confusing, but see for your self.

$search=$_POST["search"];
 
list($s1, $s2, $s3, $s4, $s5) = split('[+ ]', $search);
 
$searcharray = array($s1, $s2, $s3, $s4, $s5);
 
 echo "<table>";
foreach($searcharray as $var)
{
    if(isset($var))
    {
 
         $result = mysql_query("SELECT * FROM $dbtable WHERE keyword LIKE '%$var%'");
 
 
 
        while ($row = mysql_fetch_assoc($result))
        {    
 
 
           $id=$row["id"];
           $name=$row["name"];
           $type=$row["type"];
           $size=$row["size"];
           $keyword=$row["keyword"];
 
 
 
           ?>
          <tr><td><a href="download.php?id=<?php echo $id;?>"><?php echo $name;?></a><br />
              <?php
 
           echo "<span class=style2>keywords: $keyword<br></span><br> ";
           echo "</td></tr>";
 
        }
 
    }
}
 

(there is alot more code but it does not really have anything to do with the problem)

I thought i could use an array to store all the names of the files that have already been listed and then compare that list to every new result of the search,
but somehow i cant really get it to work out the right way.

Can someone please give me a push in a right direction?

[pbmods]

Heya, Moezzie.

Try using SELECT DISTINCT.

[Moezzie]

Thank you pbmods, that worked just perfectly.

I think im going to continue doing some work with php/mysql, its really fun stuff and has alot of great features.
I'l be back! ;)

[pbmods]

Heya, Moezzie.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)