IN and array

[searain]

For example

I have an array, student_number[]

student_number[0]=1001;
student_number[1]=1005;
student_number[2]=1007;

...

Now, I want to do a SQL to select from the table "students" with all the records if its field "number" matching any element value of the student_number[].

What is the sql it will be? Could I use "IN" somehow to do it in one sql statment?

Or I have to do embeded sqls on this?

Thanks!

[stolzyboy]

well say you have your student_number array

do this

<?
$student_number = @implode(" ", $student_number);

$query = "SELECT * from students WHERE MATCH (number) against ('$student_number');";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
echo $row['number'] . "<br>";
}
?>

[cgraz]

you could also do it like this

$query = "SELECT * FROM students WHERE number IN ('" . implode("','", $student_number) . "')" or die(mysql_error());

Cgraz