find field and put values into array?

[mrdance]

I would like to find all records where the date and name is the same as the specified varibales $date and $name. I have this field called ID. I want to find all the values of ID and store it in $ids. Then I would like to update the page with the all ID values separated with commas. I haven´t succeeded. I just find the latest ID and it's doubled, like 123456,123456. Here´s my code;

$sql ="SELECT ID FROM likvid WHERE DATUM='$date' and NAMN='$name'";
$result = mysql_query($sql,$db);

while ($idnummer=mysql_fetch_array($result)) {
$ids=IMPLODE ($idnummer,",");
}

header ("Location: likvid_update.php?ids=$ids");

Thanks!

[finger]

you use implode() not correctly:

http://www.phpbuilder.com/manual/function.implode.php

implode (",", $idnummer) may be better.

regards

finger

[[deleted]]

implode can only implode an array into a string, it can't "add" to a string or array.

In your case you want to loop through each record, and append it to an array,
and then implode that array.

$sql ="SELECT ID FROM likvid WHERE DATUM='$date' and NAMN='$name'";
$result = mysql_query($sql,$db);

$aIDs=array();
while ($row=mysql_fetch_array($result)) {
$aIDs[]=$row['ID'];
}

$sIDs = implode(',',$aIDs);

$sql="SELECT * FROM table WHERE ID in [$sIDs]";

[mrdance]

Thank you for your answers! You solved my problems!