Insert query results into other table's field delimiting with comma

[elpaisa]

Hi all!

 

I need to select some emails from one table and insert them into another table's field deleimiting them with comma, for now this is what i have:

 

       foreach($_GET['id'] as $key => $value)
    { 
                  $select_query = mysql_query("SELECT email, name FROM members WHERE id = '$value' "); 
     $member = mysql_fetch_array($select_query);
                  $emails = $member['email'];
     $update = mysql_query("UPDATE banned SET email = ".$emails."   WHERE id = '".$listid."' "); 
     
                 echo '<span style=" font-family:Arial; color:red; font-weight:bold; font-size:12px;">added: '. $member['name'].' to users banned<br /></span>'; 

          	    }

It only inserts one email into banned field, what i need to do is insert all the emails retrieved from the first query and put them delimited by comma into banned field of the banned table

[darkfreaks]

<?php

$comma_seperated = implode(",", $emails);

$update = mysql_query("UPDATE banned SET email = ".$comma_seperated."   WHERE id = '".$listid."' ");

?>

[elpaisa]

is not working i already tried this:

 

        foreach($_GET['id'] as $key => $value)
    { 
         $select_query = mysql_query("SELECT email, name FROM members WHERE id = '$value' "); 
     
	  while($member = mysql_fetch_array($select_query))
	  {
	   $emails = implode(",", $member['email']);
       $update = mysql_query("UPDATE banned SET email = '".$emails."'   WHERE id = '".$listid."' "); 
	 //echo '<span style=" font-family:Arial; color:red; font-weight:bold; font-size:12px;">added: '. $member['name'].' to users banned<br /></span>'; 
          }
	}

[darkfreaks]

look at the code above 

[sasa]

try

<?php
foreach($_GET['id'] as $key => $value) { 
$select_query = mysql_query("SELECT email, name FROM members WHERE id = '$value' "); 
while ($member = mysql_fetch_array($select_query)){
	$emails = $member['email'];
	$update = mysql_query("UPDATE banned SET email = CONCAT(email,',','".$emails."')   WHERE id = '".$listid."' "); 
	echo '<span style=" font-family:Arial; color:red; font-weight:bold; font-size:12px;">added: '. $member['name'].' to users banned<br /></span>'; 
}
}
?>

where yod define variable $listid used in query

[elpaisa]

Thanks sasa, that was exactly what i was looking for!