Explode and SELECT command

[Anon]

Hi,

I'm trying to search my database where the user select a phrase, as long as any word matches, the record will display..

This is a stupid way I have... since very likely the value I have will be within 4 words, I can do the if statement 5 times.. like this:

eg: $model = 'book worm';

$explodemodel = explode(" ",$model);

for ($i=0;$i<count($explodemodel);$i++)
{
$expmodels[$i]= $explodemodel[$i];
}
if (count($explodemodel) = 0) {

$models = 'model LIKE ' .'%explodemodel[0]%';
}
elseif (count($explodemodel) = 1) {

$models = 'model LIKE ' .'%explodemodel[0] . 'OR model LIKE' .'%explodemodel[1]%';
}

then SELECT * WHERE $models

isn't this stupid? what if the phrase has to consist of 100 words? How do I code it in a smarter way? help me out please!

[tijger]

try something like this, it should work. but maybe you need to edit it a bit...

hope it helps, greetings

<?
$query = "SELECT * FROM ".$table ." WHERE ";

if(is_array($explodemodel)) {

$value = reset($explodemodel);
for($i = 0; $i < count($explodemodel); $i++) {
    if($i == 0) {
        $query .= "model LIKE %$value%";
    } else {
        $query .= " OR model LIKE %$value%";
    }   
    $value = next($explodemodel);
}   

} else {
$query .= "model LIKE %$value%";
}

?>

[Anon]

This willl probably work, I haven't tried it, but I have somewhere around 20 SELECT commands that need this. So, is there another approach to code it so that I can simple substitude in a variable like I did earlier?

[Anon]

oops, sorry, I misread. thanks