Including array in SQL IN

[padams]

I'm trying to use the SQL IN command when I query my mySQL database, but the value I am sending in it is an array, created when users selected multiple options in a list. I've been looking around and have seen a few possible solutions involving SQL, but I'm relatively new to PHP and SQL and am not quite sure how to resolve this. Any ideas?

 

matchTeam is the array:

 

$players = $_POST['matchTeam'];

$playerGames = "SELECT * FROM players WHERE playerID IN ($players)";

$playerGames_query = mysql_query($playerGames) or die(mysql_error());

$rsPlayerGames = mysql_fetch_assoc($playerGames_query);

 

[sasa]

$playerGames = "SELECT * FROM players WHERE playerID IN (". implode(", ",$players). ")";

[padams]

Thanks, but that just returned information for the first item selected only. It also repeated it 15 times, although I only selected a few items. Any ideas?

[vijayfreaks]

Hi..

        May I know What r u getting in $players var..? check in that..

 

Regards,

Vijay

 

[padams]

$players comes from a list where users can select multiple values. The list is created dynamically and is made up of the first and last names of players belonging to our club. You can see the page at http://www.otterstouch.com/ottersdb/select3.php. It's ugly I know!

[padams]

Forgot to mention: the $players variable contains an array of integers.  These are from the playerID column in the players table, and are the primary key for that table.