mysql 逗号分割个数组,从MySQL查询将数组内嵌到以逗号分隔的字符串中

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;

}

解决方案

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.