Select where clause with "IN"

[assgar]

Hi

I would like to put a list of ids in an array
and loop to select data from a table using
"IN" in the where clause.

I am not having any success getting this to work.
Any suggestions?


Note:I am using Mysql database, apache, linux/Windows


[php]
<?
//array with list of friends to display
$friend = array('1','2',' 3','4');

$query = "SELECT first, last, number
FROM friend
WHERE id IN '$friend'";
$result = mysqli_query($m ysqli, $query);

?>

[/php]

[rpnew]

Hi

I would like to put a list of ids in an array
and loop to select data from a table using
"IN" in the where clause.

I am not having any success getting this to work.
Any suggestions?


Note:I am using Mysql database, apache, linux/Windows


[php]
<?
//array with list of friends to display
$friend = array('1','2',' 3','4');

$query = "SELECT first, last, number
FROM friend
WHERE id IN '$friend'";
$result = mysqli_query($m ysqli, $query);

?>

[/php]

I doubt whether you can use Array in such a way... cause to use array you need to walk through it.. and i dont think PHP will do it itself.. check for that...

Regards,
RP

[dlite922]

Hi

I would like to put a list of ids in an array
and loop to select data from a table using
"IN" in the where clause.

I am not having any success getting this to work.
Any suggestions?


Note:I am using Mysql database, apache, linux/Windows


[php]
<?
//array with list of friends to display
$friend = array('1','2',' 3','4');

$query = "SELECT first, last, number
FROM friend
WHERE id IN '$friend'";
$result = mysqli_query($m ysqli, $query);

?>

[/php]

You need to traverse the array in a loop and build a string that goes right in the parenthesis of the IN clause.

To get you started:

[PHP]

$inStr = "";
$foo = ('a','b','c','d ')

// build string
foreach($foo as $bar)
{
$inStr = "'" . $bar . "',";
}

// remove last comma
$inStr = substr_replace( $inStr,"",-1,1);

// build SQL
$sql = "SELECT id FROM table WHERE letter IN (" . $inStr . ")";

[/PHP]

Good luck,


Dan

[coolsti]

You could also use the implode function.

Say your array looks like

$foo = ('a','b','c','d ')

you can build the where part of the query like this:

$whereclause = "where letter in ('" . implode("','",$foo) . "')";
 

[Atli]

Yea, like coolsti says, the implode function will do the trick. I've used this method a few times myself.

Make sure to leave out the single-quote-marks tho if you are working with numbers. MySQL won't match numbers if they are quoted.