current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have and array with two values and I want to use it with sql IN operator in select query.

Here is the structure of my table

id comp_id
1   2
2   3
3   1

I have an array $arr which have two values Array ( [0] => 1 [1] => 2 )

I want to fetch the record of comp_id 1 and comp_id 2. So I wrote the following query.

SELECT * from table Where comp_id IN ($arr)

But it does not return the results.

share|improve this question

closed as too localized by Tim Post♦ Mar 8 '12 at 19:35

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.
3  
Step 1 is to debug your own code. If you printed out the query you were sending to MySQL, you'd see that SELECT * from table Where comp_id IN (Array) is not right. Trying to concatenate an array to a string doesn't automatically turn it into a comma separated list of words. –  Dan Grossman Mar 8 '12 at 13:23
4  
Step 2 is to search SO to find out how many thousands of times this question has already been answered –  Mark Baker Mar 8 '12 at 13:25
    
I'm closing this as too localized because it seems like (after reading comments) that $arr is probably not an array. Hence, the problem probably doesn't match the question :) If my call was in error, please flag your question for moderator attention. –  Tim Post♦ Mar 8 '12 at 19:35

9 Answers 9

up vote 14 down vote accepted 
$sql = "SELECT * from table Where comp_id IN (".implode(',',$arr).")";
share|improve this answer
    
I used this method and it works fine but with a warning of Warning: implode() [function.implode]: Invalid arguments passed in C:\wamp\www\x\x\x\xxx.php on line 81 –  Ahmad Mar 8 '12 at 13:43
1  
@Ahmad Your $arr is most likely not an array. Check that you are constructing it properly. –  jprofitt Mar 8 '12 at 13:51
up vote 2 down vote

$arr is a php array, to the sql server you need to send a string that will be parsed you need to turn your array in a list like 1, 2, etc..

to do this you can use the function http://php.net/implode

so before running the query try

$arr = implode ( ', ', $arr);
share|improve this answer
    
I used this method and it works fine but with a warning of Warning: implode() [function.implode]: Invalid arguments passed in C:\wamp\www\x\x\x\xxx.php on line 81 –  Ahmad Mar 8 '12 at 13:43
    
@Ahmad that's strange.. maybe for a case where you don't have elements in that array or the variable is not initialized yet.. ? –  mishu Mar 8 '12 at 13:52
up vote 2 down vote

you need to convert the array into comma-separated string:

$condition = implode(', ', $arr);

And, additionally, you might want to escape the values first (if you are unsure about the input):

$condition = implode(', ', array_map('mysql_real_escape_string', $arr));
share|improve this answer
up vote 2 down vote

you can only pass string to mysql as query, so try this

mysql_query("SELECT * FROM table WHERE comp_id IN (".implode(',',$arr).")");
share|improve this answer
up vote 1 down vote

You need to implode your array with ',' comma

$imploded_arr = implode(',', $arr);

SELECT * from table Where comp_id IN ($imploded_arr)
share|improve this answer
up vote 1 down vote

You need something like:

$sql = "SELECT * from table where comp_id in (".implode(',',$arr.")";
share|improve this answer
up vote 1 down vote

You need to actually convert your $arr to a string. The simplest way with what you're doing would be to use implode()

$query = 'SELECT * from table Where comp_id IN (' . implode(',', $arr) . ')';

Right now if you echo your query you'll see that rather than the array being in the IN statement, it will just be the word "Array"

share|improve this answer
up vote 1 down vote

You need to convert the array to a string for use in the query:

$list = implode(',', $arr);

Then it can be used in the IN clause:

SELECT * from table Where comp_id IN ($list)
share|improve this answer
up vote 1 down vote

You're mixing PHP and SQL - for the IN SQL operator, you need a format like:

SELECT * from table WHERE comp_id IN (1,2)

So to get that in PHP you need to do something like:

$sql = "SELECT * from table Where comp_id IN (".implode(',',$arr).")"

Bear in mind that this only works if the array comprises of integers. You have to escape each element if they are strings.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.