General Array Query

[Anon]

Ok, I'm trying to take a string from a HTML for (a+b+c+d...) and split it up at the + delimiter, and then have mysql match all values in that array in any order...

What I think I have to do is:

$terms = explode("+",$variable);

for($i=0, $i < count($variable)😉 {
$term"$i" = $terms[$i];
$i++;
}

Then how would I take that number of variables, and compose a select ... from ... where $term1=a AND $term2=b...;

Thanks for the help.

[cordex]

$terms = explode("+",$variable);
$sel_st = "SELECT * FROM table WHERE ";

for($i=0, $i < count($variable);$i++) {
if($i == 0) $sel_st .= "term$i=$terms[$i] ";
else $sel_st .= " AND term$i=$terms[$i] ";
}

Also, if you want to name a variable with a variable (as attempted in: $term"$i" = $terms[$i]😉 You have to use: ${"terms" . $i}.