select query with array?

doobster

Hello if I have the following array:

$array1 = array("option1", "option2", "option3");

How do you use an array in a where clause?

Is it the same syntax as if it were a scalar? (select * from table where field1 = '$array1'

Or do you do need to do something different?

bubblenut

All that the database recieves is a simple string (the sql query) therefore you cannot have complex data types. You must expand out your array.

<?php
$sql="select * from table where ";
for($i=0;$i<count($array);$i++) {
  $sql.=($i>0?' || ':'')."coulumn='".$array[$i]."'";
}
//or possibly even
$sql="select * from table where column='".implode("' || column='",$array)."'";
//although I'm not sure if that second one works, try it and see.

HTH
Bubble

nlhowell

Maybe more useful:
[edit] doh! I'm such a dope. didn't realize what you were trying to do. it might be useful for some other use, but in this case it's not. sorry.[/edit]

<?php
$array = array('field1'=>'value1','field2'=>'value2');

$query = "SELECT * FROM table WHERE ";
foreach($array as $j => $i)
{
    $query .= "$j = '$i' AND ";
    //$query .= "$j = '$i' OR "; would work too
}
$query .= "1=1;"; // "SELECT * FROM table WHERE field1='value1' AND field2='value2' AND 1=1;"

LordShryku

Actually, bubblenut was on to something with the second one, but the "IN" operator would be more useful here.

$sql = "SELECT * FROM table WHERE column IN ('".implode("','",$array)."')";