Multiple query variables based on str_word_count - MySQL

[Jeff]

Greetings:

I am attempting to split an input string using the str_word_count
function to return multiple single word query variables.
I can create an array based on
$search=(str_word_count($search, 1, '0123456789')); (I want words and/or
numbers).
I can extract named variables from the resulting array via
$search=extract($search, EXTR_PREFIX_ALL, search);
and then call each variable by
$search_0 $search_1 $search_2, etc.
Several issues that I am having:
Since the size of the array is determined by user input. I can't
hardcode $search_x, $search_y, etc. because I don't know what x, y, etc.
will be. How can I produce $search_x... et al. and then hand it/them to
a query string? I can echo desired output using for or while loops,
(i.e. the *value* of $search_x...et al. but I can't figure out how to
get them into query strings. I want my query strings to contain
something like

$q="
SELECT *
FROM *
WHERE table1.row1
LIKE '%$search_x%'
OR LIKE '%$search_y%'
etc..."

Advice or a sanity check is appreciated.

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn

[Jerry]

Jeff Gardner wrote: 

Don't bother extracting. Just build your string in a foreach loop, i.e.

$str = '';
foreach ($search as $s) {
if ($str != '')
$str .= ' OR ';
$.str .= "LIKE $s";
}
$sql = "SELECT * FROM table1 WHERE row1 $str";

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
net
==================

[Jeff]

Jerry Stuckle wrote: 
>
> Don't bother extracting. Just build your string in a foreach loop, i.e.
>
> $str = '';
> foreach ($search as $s) {
> if ($str != '')
> $str .= ' OR ';
> $.str .= "LIKE $s";
> }
> $sql = "SELECT * FROM table1 WHERE row1 $str";
>[/ref]
This is what ended up working:

$table=array(
'table.column',
'table.column2',
etc...
);

$str = '';
foreach ($search as $s) {
foreach($table as $t){
if ($str != "")
$str .= "OR\n";
$str.= "$t\n" ;
$str .= "LIKE '%$s%'\n";
}}
$q = "
SELECT
$alias
FROM table1
LEFT JOIN table2
ON table1.id = table2.id
WHERE
$str
";

Thanks for pointing me in the right direction.

--

Regards,

Jeff Gardner
___________________________

"Contrary to popular belief, Unix is user friendly. It just happens
to be very selective about who its friends are." --Kyle Hearn