How to convert an array of values ​​returned from a query to comma separated values

Question

I have a result set that is returned using this code:

while ($row = mysql_fetch_array( $result )) { echo "ID ".$row['v2id']; } 

it returns ID 2ID 3ID 4ID 8

how would I convert this to comma separated values ​​and then store them in a variable?

therefore, if I chose a variable, the final result should look like 2, 3, 4, 8

Answer 1

save all the values ​​in an array, then attach them using "," as glue

 $values = array(); while ($row = mysql_fetch_array( $result )) { $values[] = $row['v2id']; } echo join(", ", $values); 

Answer 2

Add all the values ​​to the array, then implode using ', ' as glue

 $result = array(); while ($row = mysql_fetch_array($result)) { $result[] = $row['v2id']; } echo implode(', ', $result); 

Answer 3

 $data = array(1,2,'Hello',3,4,'1,234.56'); $outstream = fopen("php://temp", 'r+'); fputcsv($outstream, $data, ',', '"'); rewind($outstream); $csv = fgets($outstream); fclose($outstream); 

Answer 4

 $ids = array(); while ($row = mysql_fetch_array( $result )) { $ids[] = (int)$row['v2id']; } echo implode(", ", $values); 

1ID 2ID 3ID 4ID 8 can be converted to int by (int) $ row ['v2id'], so $ ids will only contain int.

Answer 5

My way would be like this

  $ csv = '';
 while ($ row = mysql_fetch_array ($ result)) {
    / * Note the '. =' - appends variable * /
    $ csv. = "ID". $ row ['v2id'];
    $ csv. = ',';  // This is the bit I missed out
 }
 / * Remove the final trailing comma * /
 $ csv = substr ($ csv, 0, -1);
 echo $ csv; 

The golden star goes into ssapkota to determine the "intentional" error p>