[Roderik]

as i said, was bored, didn't even install the mod yet zo i based what $keywords would be from the little example at the mySQL manual

* What about complete phrases enclosed by quotes?
I think your implementation will treat it as individual words.

it does indeed, and it will break if you try but that can be fixed by

PHP Code:

    $lastgood = 0;
    $lastsign = true;
    
    for ($i=0; $i < sizeof($kw); $i++){
        if ($kw[$i]{0} == '+'){
            array_push($kwplus, substr($kw[$i], 1));
            $lastgood++;
            $lastsign = true;
        } else if ($kw[$i]{0} == '-'){
            array_push($kwmin, substr($kw[$i], 1));
            $lastgood++; 
            $lastsign = false;  
        } else {
            if ($lastsign){
                $kwplus[$lastgood] .= ' ' . $kw[$i];         
            } else {
                $kwmin[$lastgood] .= ' ' . $kw[$i]; 
            }
        }      
    } 


* What about asterisk?
I think this is a major problem. If I search for hack (with mySQL 4) it would not return rows containing hacks - your implementation would.
If I search for hack* (with mySQL 4) it would return rows containing hack, hacks, etc. - your implementation would return nothing.

indeed, also true , just stripping these special chars would do the trick, only thing, searching for hack* could be betaHacks as well.

But it can be fixed too , by replacing * with % and in the code that builds of the sql we remove the %'s from the strings

* What about negation?
It seems like you don't support this at all, treating it as part of a word.
Now if I search for ~vB3 (with mySQL 4) it would return rows that do not contain vB3, your implementation would return those only.

you can use + and -, so the - does negation
name NOT LIKE '%".$kwmin[$i]."%'
so name won't contain $kwmin[$i]

what does the ~do other than de - ?

* What about sub-expressions?

yeah that doesn't work it's a backward fix, if everyting was so easy they would have put it in in version 1

* What if you do not put a plus/miuns in front of a word?
It seems link in this case your implementation would strip off the first character and treat them as NOT words.

also correct, partially fixed in the code above. But it does indeed depend on the correct input from the script that calls it.