[Resolved] Search with php and mysql

[TheBeginner]

Hi,

I would like some suggestions nad help with a serach engine I would like to do on my homepage.

I want to just search in one table and the user gets a form to fill in. If the user fill in for 1 (one) word to serach for the SQL question will look like this:

$result=mysql_query("SELECT * from $table WHERE text LIKE '%$searchterm'");

The variable $searchterm comes from a HTML-form.

This is easy even for a beginner like me, but what if the user wants to search for more words (for example: "car 2003 new").
This is 3 words!

I guess I will the have to divide the variable $searchterm in several ones and then have a new question to the database.
How can this be implemented so the user can make the search having how many words he want?
I have no clue how to do that. Have anyone of you done that?

[OhLordy]

<?
$query_string="";
$terms=explode(" ",$searchterm);
for($i=0;$i<count($terms);$i++)
{
  $query_string.= ($i!=0) ? " || ";
  $query_string.=" text='%".$terms[$i]."'";
}
$result=mysql_query("SELECT * from ".$table." where ".$query_string);
?>

HTH
Rob

[TheBeginner]

Many thanks for the code. I actually made something similar right after I posted this thread. Sometimes an idea appears just like that! It was basically the same principle I tried to use.

But it is still great to get almost the same answer from somebody else!

Thanks one again!