Need help with search-query

Anon

I want to create a mini searchengine with PHP and MySQL.
The created MySQL-table contains 4 fields:
linkTitle - The title of the website (ex. Anna Kournikova Online)
linkURL - The URL of the website (ex. http://come.to/annaonline)
linkDescription - A short description (ex. Anna Kournikova fansite)
linkKeywords - Some keywords (ex. kournikova, tennis, pictures)

The user of the seachengine must enter some keywords in a
textfield. I have now problem searching a website if the user
only entered 1 word. I just use the following SQL:
$sqlquery = "SELECT * FROM $table WHERE urlTitle LIKE '%$searchstr%' OR
urlKeywords LIKE '%$searchstr%'";

But what if the user entered multiple words in the textfield?
I can use explode (sort on " " (whitespace)), but how can I construct
a good SQL-query with the words?

Thanks in advantage...

Ron, The Netherlands

cvincent

Check out my project http://owl.sourceforge.net. Download it, and look at the search.php file. It was built to search a table that contains keywords, a description, a title, and a filename but you can change it very quickly. It takes each word the user entered and compares it to each word in the fields, and depending on which field it matches, gives +1,+2,+3, or +4 to the score, and prints the results in order of highest to lowest score (and doesnt print things with score of 0).

-Chris

mp96brbj

// When you've recieved the query:

$querywords = explode(' ', $query);

// I'm doing a hack here; I compare id (or any column) to itself so I
// can start all following arguments with OR, and still have WHERE in the syntax.
$sqlquery = "SELECT * FROM $table WHERE id=id";

foreach ($querywords as $word)
{
$sqlquery .= " OR urlTitle LIKE '%$word%' OR urlKeywords LIKE '%$word%";
}