eregi_replace ?

I have a small mysql db where people can do a search. What is the best way to parse the searchstring ?

Maybe something like this ?
eregi_replace= ("search for space, LIKE ,$output")

But what if someone makes a space after the last entry like "text book "

You may use any thing like it:

if (strlen($keyword) < 2)
print "the keyword must be >= 2 chars";

$strQuery = eregi_replace (" ","%\" OR field LIKE \"%", $keyword);

$strQuery = "(field LIKE \"%" . $strQuery . "%\")";

$sSQL = "SELECT * FROM table WHERE $strQuery";

Fernando Figueiredo Torres
Belo Horizonte, MG, Brazil

Thanks, just what I was looking for 😉

Sorry, this is my reply FIXED :o)

// $txtKeys was submited via form.

$tmpKeyword = trim(strip_tags($txtKeys));
if (strlen($tmpKeyword) < 2)
{
print "insuficient parameters";
exit();
}

$tmpKeyword = explode (" ",$tmpKeyword);

$strKeyword = "(";

for ($i=0;$i < sizeof($tmpKeyword); $i++)
{
if (strlen($tmpKeyword[$i]) >= 2)
$strKeyword .= "field LIKE '%$tmpKeyword[$i]%' OR ";
}

if (substr($strKeyword,-3) == "OR ")
$strKeyword = substr($strKeyword,0,-3);

$strKeyword .= ")";

if ($strKeyword == "()")
{
print "the keywords need be >= 2 characters";
exit();
}

$strQuery = "SELECT * FROM table WHERE $strKeyword";

// This is functionaly? Send-me comments

Fernando Figueiredo Torres
Belo Horizonte, MG, Brazil

At work not able to test it right now, but looks really good. I'm sure I can use it