[RESOLVED] Need help with displaying items from mySQL

Rodney_H_

I have a very simple search engine on a site. I just noticed that there is a problem with it.

When I search for 'wheels', there are 200 results.
When I search for 'wheel' there are 400 results.

I have both words, wheel and wheels, in my keywords table.

Is there something I can do in my query SELECT statement or my while loop to eliminate duplicates?

while loop:

<?php

	//grab all the content
	while($row = mysql_fetch_assoc($result)){
		$id = $row['link_id'];
		$name = $row['name'];
		$des = $row['description'];
		$url = $row['url'];
		$host = $row['host'];			
		// define output of results	
		$match = '<h4>' . $name . '</h4>' . "\n";
		$match .= '<p>' . $des . "\n";
		$match .= '<br /><a href="' . $url . '" />' . judochop($url) . '</a></p>' . "\n";
		// put results into a new array that I can index
		$resultsArray[] = $match . '<br />' . "\n";				
	} // .while

?>

Thanks!

subwayman

how about:

 
        while($row = mysql_fetch_assoc($result)){ 

        $id = $row['link_id']; 

        if ($lastid != $id){

           $name = $row['name']; 
           $des = $row['description']; 
           $url = $row['url']; 
           $host = $row['host'];             
           // define output of results     
           $match = '<h4>' . $name . '</h4>' . "\n"; 
           $match .= '<p>' . $des . "\n"; 
           $match .= '<br /><a href="' . $url . '" />' . judochop($url) . '</a></p>' . "\n"; 
           // put results into a new array that I can index 
           $resultsArray[] = $match . '<br />' . "\n";
           $lastid = $id;  //save the id to check against next
        }// .if

    } // .while

This should only output a link once. But it does assume the links are sorted from the query.

If you want the query to do it for you and not give you all the matches in the first place then add a DISTINCT to your query. This will casue mysql to return each unique record only once.

Rodney_H_

subwayman wrote:
If you want the query to do it for you and not give you all the matches in the first place then add a DISTINCT to your query. This will casue mysql to return each unique record only once.

I had tried DISTINCT before posting here, but kept getting a mysql error.

[INDENT]$query = "SELECT links.DISTINCT ";[/INDENT]

Then, I RTF*M (again, after your suggestion) and came up with a solution:

[INDENT]$query = "SELECT DISTINCTROW links.* ";[/INDENT]

That wasn't too bad. Thanks again for pointing me in the right direction.

Kind regards.