mysql only returning last result instead of array

Jon7800

I have posted the following 3 ID's to a php page via an array.
This page needs to do some sql processes:

The IDs are:
25, 26, 17

I have printed the 3 ID values with the following code:
($idString being the variable passed via an array from the previous page)

<?
foreach($idString as $idValue) {
echo "$idValue<BR>";
}
?>

The mysql query code is this:
<?

$db_name = "thepond";

$table_name = "employees";

$connection = @mysql_connect("localhost", "root", "") or
die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "SELECT *
FROM $table_name
WHERE id = \"$idValue\"
";

$result = @mysql_query($sql,$connection)or die "Couldn't execute query!");

while ($row = mysql_fetch_array($result)) {


$FirstName = $row['FirstName'];
$LastName = $row['LastName'];
$Email = $row['Email'];
$Extension = $row['Extension'];
$Branch = $row['Branch'];
$Department = $row['Department'];
$Title = $row['Title'];
$Birthday = $row['Birthday'];
$SymitarID = $row['SymitarID'];
$Account = $row['Account'];

}

$EmployeeName .= "$FirstName $idValue";

when i print or echo the Employee Name, i only get the last record:

Tami 17

Please advise on how I can get all records for each ID selected out of the database. Thank you! -Jon

YappyDog

Unless you build and print your $EmployeeName variable within your while loop (it's outside it now), you will always only see the last one.

You need to change your while loop to either store your values into arrays, or do all your processing inside the loop.

Jon7800

I beleive the problem actually stems back to my SELECT statement, because $idValue in this state is only equal to the last id record from the post.

Is there a way to break up the array when doing a SELECT from mysql, so that i can SELECT from Table WHERE id = each id in the array that was posted over? In this case I need a dynamic way of pulling just ID's 25,26, 17.

So i need to dynamically write this:

$sql = "SELECT *
FROM employees
Where id = 25 OR id = 26 OR id =17

Then i can do whatever i want with the data pulled from those 3 ID's.... So in a nutshell, how do you use the Array pulled over from the post, to select only those IDs that are in the array?
Thanks, -Jon

YappyDog

$sql = "SELECT * FROM employees Where id in (25, 26, 17)";

Jon7800

Thank you!

once i figured out how to generate this:

$sql = "SELECT * FROM employees Where id in (25, 26, 17)";

I was fine. I used this to do it:

$sql = "SELECT *
FROM $employees WHERE id IN (";
foreach ($idString as $idvalue) {
$sql .= $idvalue . ",";
}
$sql = substr($sql, 0, -1);
$sql .= ")";

Now my question is...I want to INSERT INTO a different table information for these same ID's. (in this case, the 3 ID's). The information will all be the same, i just want 3 rows, one for each of the selected ID's. Can anyone provide me with help for this??

Thanks in advance! - Jon