Getting data from an array

asa_carter

Hi,

Does anyone know the syntax for getting data from a table where a field must equal anything in an array?

$item_query = "SELECT * FROM item WHERE id = ???";

Cheers

Asa

LordShryku

[man]implode[/man] the array into the query string, and use the IN operator instead of =

asa_carter

//  Put the array into a string and separate them with comma's
$comma_separated = implode(",", $thearray);

//  Get all database results from the item table that are in the string
$item_query = mysql_query("SELECT * FROM item WHERE id IN $comma_separated", $mysql_access);

while($row = mysql_fetch_row($item_query))
  echo "$row[0], $row[1]";

Returns this error -

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Group\Apache2\htdocs\cdburn\do_data.php on line 30

Am i using IN correctly?

LordShryku

Provided id is a int type field, you're almost there. If not, you'll need to single quote the values. Otherwise, just the parens around the values will do:

$item_query = mysql_query("SELECT * FROM item WHERE id IN (".$comma_separated.")");