Select from and insert array into DB

[Jon7800]

Hello all,

I have an Array that looks like this:

Array ( [0] => 28 [1] => 29 [2] => 10 )

These are ID values pulled from an "Employee" table out of mySQL. I would like to take these ID's and post them to a php page that would then do the following:

Pull all information from the 'Employee' Table for each of the ID's,

Insert some of that information into another Table.

Send an email to each of the ID's (the email address is one of the values pulled from the 'Employee' table).

Basically, i just need to know how to exctract the ID values out of that array, and then do those 3 tasks with the ID's.
Any help is GREATLY appreciated!

Thanks, Jon

[nlhowell]

To select the correct record out of the database:

$query = "SELECT * FROM employees WHERE ID = ".$array[0]." OR ID = ".$array[1]." OR ID = ".$array[2];
$result = mysql_query($query);

To grab the records:

while($row = mysql_fetch_assoc($result))
{
    $records[] = $row;
}

That stores it like this:

array(
    array('col1'=>'val1') // record 0
    array('col1'=>'cats') // record 1
    // etc...
);

To print the info:

print "<table>";
foreach($records as $record)
{
    print "<tr>";
    foreach($record as $field)
    {
        print "<td>$field</td>";
    }
    print "</tr>";
}

To send an e-mail:

foreach($records as $record)
{
    mail($record['email'],"Hi, this is the subject!"," And this is the body");
}

[Jon7800]

In my example, i have only 3 ID's, but there is the potential of selecting up to 100....

is there a way to do this query:

$query = "SELECT * FROM employees WHERE ID = ".$array[0]." OR ID = ".$array[1]." OR ID = ".$array[2];
$result = mysql_query($query);

with the potential of unlimited IDs?