multiple keyword search string...

[viveleroi0]

I have been using the following code to breakup a text box and use each keyword to search a database...

but I would now like to display in the page those keywords after they have been seperated (maybe in an array?)...

Yet when I try to echo the query, I get the % signs in there too. Any ideas?

	$words = split(" +",addslashes($formdata));
	$total_words = count($words);
	$query = "SELECT * FROM $Product_DB WHERE ";
	$query .= "ProdDesc LIKE \"%" . $words[0] . "%\" ";
	for($x=1;$x<$total_words;$x++)
		{
		$query .= "AND ProdDesc like \"%" . $words[$x] . "%\" ";
		}

[gammaster]

Try this.

$words = split(" +",addslashes($formdata));
/*
if you dont want a search for all in the table
you can break here if there are no $words. But the script can get it all.
*/

$query = "SELECT * FROM $Product_DB"; 

foreach($words as $key => $word) {
   if($key == 0)
      $query.= " WHERE (ProdDesc LIKE '%$word%'";
   else if($key > 0)
      $query.= " OR ProdDesc LIKE '%$word%'";
   if($key == sizeof($words) - 1)
      $query.= ")";
   }

[gammaster]

Sorry but i forgot the displaying stuff.

foreach($words as $word)
   echo stripslashes($word).'<br>';

ofcourse there are '%' inj your query, you have added them u self..🙂.