Extract values from array

can echo but need it to be stored in an individual variables

[abushahin]

Hi, I have taken this example from www and have amended it to stem words for searching db, I need help extracting the values and then searching againgst my db.

require_once'class.stemmer.inc';
$title = "walking and talking";
$stop_words = array("the", "and", "a", "to", "of", "in", "i", "is","that", "it", "on", "you", "this", "for", "but",
"with", "are", "have", "be", "at", "or", "as",   "was", "so", "if", "out", "not");
$stemmer = new Stemmer;
$words = explode(" ", $title);
foreach($words as $word) {
$stem = $stemmer->stem($word);
if(!in_array($stem, $stop_words)) {
   $stem_words[] = $stem;
  }
}
foreach ($stem_words as $k=>$v) {
echo "$v ";
}

now this echos walk talk which is correct but i need it to be in a variable or somehow need this to be inside an sql query i dont want to put the sql query inside the foreach as that will do multiple queries, is there any way i can achieve this?
any help appreciated.

[rocknbil]

What's the query? Select, insert, update, delete?

[abushahin]

Rocknbil, it's going to do a select query.

[Chico_Loco]

foreach ($stem_words as $k=>$v) {
if (!$SQL)
{
$SQL.="field_name='$v'";
}
else
{
$SQL.=" OR field_name='$v'"
}
}

$SQL="SELECT * FROM db WHERE $SQL";

// Whatever code to run your $SQL query here;

[httpwebwitch]

SELECT * from table WHERE column IN ('walk','talk')

[abushahin]

Thanks for the replies guys, just wondered what this is?

if (!$SQL)

[rocknbil]

It means if the where statement has not been built, don't use or. Another way,

$where=null;

foreach ($stem_words as $k=>$v) { 
 // only add "or" if the where statement has already been started 
 if ($where) { $where .= ' or'; } 
 $where .=" field_name='$v'"; 
} 

$select = "select * from table";
if ($where) { $select .= " where $where"; }

Note the spaces, important.
If you use these in combination with AND, the or's will need to be wrapped in parentheses ()

[abushahin]

Thanks a million!