Parse input string, pass to WHERE clause

[Anon]

Ive tried and Ive tried, but nothing seems to work. My objective is simple: I want to do a 'SELECT foo WHERE bar LIKE $var' for each word in a string separately, Not the whole string. (The string is text box input.) How can I loop through each word and pass it to the WHERE clause? I tried strtok and as an array.

The following code does not return a result when I know it should. If you have experience with this please help.

//'$find' is text box input
$words=split(" ", $find);
print "Query=$words[0]<hr>";
$words[0]=$one;
$sql=mysql_query ("SELECT bandname
FROM bands
WHERE bandname LIKE '$one%'
");
while ($myrow=mysql_fetch_array($sql))
{
print "$myrow[0], '$words[0]'<p>";
}

[chowdary]

Hi Mark,
I am not aware of split() function(reg existance).Try this

 if(!$find || $find=="")
 {
    echo "No words";
 }
else
 {
     $word_arr=explode(" ",$find);
     for($i=0;$i<sizeof($word_arr);$i++)
     {
       $search=$word_arr[$i];
       $qry="select...................where bandname like '%$search%'";
      }

 }