Arrays, please help!

[peppino]

i want to turn results of a query into a comma delimited string (using implode) of the values. do i use arrays to do this?

the query is as follows

SELECT groupMemberEmail FROM groupmap WHERE groupId='$groupId'

groupMemberEmail's value is an email address

so say there are 3 rows found in the database. how do i turn that list of emails into a comma delimited string such as

$string = "[e-mail],[e-mail],[e-mail]

please help!

[drawmack]

just use the mysql_get_row command and then implode the results

[peppino]

Originally posted by drawmack
just use the mysql_get_row command and then implode the results

but there will be more then one row that meets the SELECT query.

row1 = [e-mail]
row2 = [e-mail]
row3 = [e-mail]

how do i get the results of these rows and turn them into
$results = [e-mail],[e-mail],[e-mail]

thanks!

[drawmack]

<?php
while($row = mysql_get_row($query)) {
  $variable .= implode(",",$row);
}
?>

[TTT]

 <?php 
$variable = "";
while($row = mysql_get_row($query)) { 
  $variable = $variable.$row[0]; 
} 
$variable = substr($variable,0,strlen($variable)-1); // rip last comma
?> 

[peppino]

Thanks guys!