implode an array into a comma separated string from mysql query
41,458
Solution 1
Try something like this:
$ids = array();
while ($row = mysql_fetch_assoc($result))
{
$ids[] = $row["UserID"];
}
echo implode(", ", $ids);
Replace "UserID"
with the columnname of the id in your table.
So: first you build the array, next you implode the array into a string.
Solution 2
There is my solution:
SELECT GROUP_CONCAT(UserID) as string FROM Users;
For this function the delimiter is ',' by default.
Author by
anjelott1
Updated on May 12, 2020Comments
-
anjelott1 about 4 years
For the last 1 1/2 days I've been trying to store 16 row id's into a string and separate each id with a comma. The array I am getting is from MySQL. The error I am getting is
implode() function:passed invalid arguments
$str=array(); $string=""; while($row = mysql_fetch_row($result)) { $user_id=$row; $str=$user_id; foreach($str as $p=>$v){ comma($v); } } function comma($v){ $string= implode(",",$v); echo $string; }