[mocremilo]

I have an array containing an uncertain number of unique id's (12,4,56,32 for example). What I need to do is select rows from a MySQL table by each unique id contained within the array.

How should I do this?

[rob*]

you could use a WHERE ... IN sql statement

SELECT * FROM table WHERE id IN(first_id, second_id, third_id...)

set up a foreach loop and just output the array values separated by a comma between the parenthesis.

HTH

[MikeMackay]

Well if you are using PHP then you can use the built in function "array_unique". Basically, take your array in IDs and parse it through that function to strip out all the non-unique ID numbers. Then all you need to do is loop through the new array and do a SELECT on each row to get the corresponding data.

Barebones example:

PHP Code:

$someIDs = array(1,2,2,4,5,6,7,2);
$uniqueIDs = array_unique($someIDs);

foreach ($uniqueIDs as $idNumber)
{
...MySQL SELECT QUERY HERE...
} 


Hope that helps.

- Mike

[cam]

rob*'s example is far better. less queries.

[MikeMackay]

Yes I agree on that, it would be better to use one query as opposed to many. I'm guessing that the IN part of the query will ignore non-unique IDs? If not, you could still make use of the array_unique function before running the SQL query.

Otherwise, forget my idea

- Mike

[mocremilo]

Thanks for the fast help guys. rob*, that really did the trick. Here's how I used it:

PHP Code:

$ids = implode(",", $ids_array);
$query = "SELECT * FROM table WHERE id IN(".$ids.")"; 


It's probably not the right way to do it, but it worked.

[haku]

That's a nice little piece of code right there. I will probably use it in the future.

Although it won't work as is if you are checking strings. I think you could make it work with strings like this:

$ids = implode("', '", $ids_array);
$query = "SELECT * FROM table WHERE id IN ('".$ids."')"; 

[prydie]

that works, nice !