multiple word entry search box

[paulmo]

mysql 4.1, phpadmin, myisam, and 'terms' field is text.

 

my search box is matching fine for one word, but not working for multiple words. for example, "yellow" in search box echoes correct table field ('terms') row about a yellow sun, etc. but "yellow dog in the road" in search box echoes "try again." the user will be writing at least one tence, and i need any word in that sentence to echo the matched table field row.

the form:

<form name="search" method="post" action="beta.php">
<center>Write something: </br></br>
<input type="text" name="find" class="buttonsb"/> 
<input type="hidden" name="searching" value="yes" /></br></br></br>
<input type="submit" name="search" value="Process" class="buttons" />
</center>
</form>

the code:

$searching = $_POST['searching'];
$find = $_POST['find'];

if ($find == "") 
{ 
echo "Please write something."; 
exit; 
} 

mysql_connect("xxx") or die(mysql_error()); 
mysql_select_db("xxx") or die(mysql_error()); 

$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find); 

$data = mysql_query("SELECT * FROM beta WHERE terms LIKE'%$find%'"); 

while($result = mysql_fetch_array($data)) 
{ 
echo $result['terms']; 
echo " "; 
} 

$anymatches=mysql_num_rows($data); 
if ($anymatches == 0) 
{ 
echo "try again.<br><br> "; 
echo "You wrote: " .$find; 
} 
?> 

thanks for help or suggestions.

[fenway]

Sounds like you need to split on spac.

[paulmo]

wow, guess i should have stated i'm a relative newbie at this; i'd be clueless about what split on spac means, or how to apply that expression to the code i've presented.

[fenway]

spac = space with a typo.....i just meant to use LIKE to search on each word in the string.

[paulmo]

but the form is to search on any word that's submitted (like 100's of words); LIKE is too limiting. any other ideas? thanks

[fenway]

Not sure what you mean by "limiting"... it will find any word that matches...

[paulmo]

ok, i understand. how to split on space in this query?

thanks

[paulmo]

is any of this getting close?

 

$message = strtoupper($message); 
$message = strip_tags($message); 
$message = trim ($message); 
$message = str_split($message); 
$name = trim ($name); 
$name = strip_tags($name); 
$name = mysql_real_escape_string($name); 

//$message = preg_split("/[\s,]+/")

$data = mysql_query("SELECT * FROM xxx WHERE terms LIKE'%$message%'"); 

while($result = mysql_fetch_array($data)) 
{ 
echo $result['terms']; 
echo " "; 
} 

[fenway]

Not really.. you need a LIKE for each word.