How to send an array of values to an SQL statement?

[Jeanco]

At the moment I have a database with a table called 'rankings'. In this table are unique IDs and a netValue which I use to rank people by.

I show 20 people at a time, so my current query looks like this:

$query = "SELECT * 
          FROM rankings 
          WHERE comp_id='".$comp_id."' 
          ORDER BY netWorth DESC";
($limit != "" ? $query .= " LIMIT ".$limitStart.", ".$limit : ""); 

What I have is an array of user ids. I'm wondering if there is something in SQL similar to the in_array() function. Essentially I want to do the query above but add something like:

AND uid = in_array($myArrayOfUIDs)

How should I go about this? I'm guessing there's a more efficient way of doing this then looping the array and adding a bunch of

"OR uid = '".$myArrayOfUIDs[$x]."'"; 

Thanks in advance.

[kromey]

The quickest way I've found to do this is to use PHP's implode function to turn your array into a comma-delineated string, then use that in a MySQL IN clause, like so:

$string = implode(",", $array);
$query = "SELECT * FROM table1 WHERE field1 IN ($string)";

Of course, this will only work for numerical values. If you have an array of strings, then use "','" as your implode glue, and don't forget to add the quotes in your query as well ("...IN ('$string')"). Oh, and as always, run your string through mysql_real_escape_string first (you must do this before you implode them, otherwise you'll escape the quotes you added and will end up with just one really long string).

[Sillysoft]

At the moment I have a database with a table called 'rankings'. In this table are unique IDs and a netValue which I use to rank people by.

I show 20 people at a time, so my current query looks like this:

$query = "SELECT * 
          FROM rankings 
          WHERE comp_id='".$comp_id."' 
          ORDER BY netWorth DESC";
($limit != "" ? $query .= " LIMIT ".$limitStart.", ".$limit : ""); 

What I have is an array of user ids. I'm wondering if there is something in SQL similar to the in_array() function. Essentially I want to do the query above but add something like:

AND uid = in_array($myArrayOfUIDs)

How should I go about this? I'm guessing there's a more efficient way of doing this then looping the array and adding a bunch of

"OR uid = '".$myArrayOfUIDs[$x]."'"; 

Thanks in advance.

$uidarray = implode(',',$array);
 
$query = "SELECT * FROM rankings 
               WHERE comp_id='".$comp_id."' 
               AND uid IN($uidarray)
               ORDER BY netWorth DESC"; 

Silly

[Sillysoft]

Im too slow!

Silly

[Jeanco]

Thanks guy, didn't think of that.

[Jeanco]

I've got this set up now, but its only returning the first occurrence it finds instead of all of them.

Any ideas?

[Jeanco]

Nevermind, figured it out. Even though I'm using numbers, they are being treated as strings. I needed to change the implode glue.

Thanks