Inserting data from query

[Canman2005]

Hi all

 

I have a simple query

 

$sql = "SELECT * FROM siteusers";
$query = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($query))
{
print $row['email'].'; ';
}

 

This basically produces something like;

 

email@domain.com; myname@domain.com;

 

How can I define these as a variable such as

 

$allemails;

 

So that I can insert it into a INSERT query.

 

And lastly, how can I remove the symbol ; from the last row returned

 

Can anyone help?

 

Thanks

 

Dave

[Caesar]

Using your existing code....

 

<?php

$sql = "SELECT * FROM siteusers";
$query = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($query))
{
$emails[] = $row['email'];
print $row['email'].'; ';
}

?>

 

This will create an $emails array that will store all the emails in that loop. If you want to store it in one long string instead of using an array...

 

<?php

$sql = "SELECT * FROM siteusers";
$query = @mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($query))
{
$emails .= $row['email'].' ';
print $row['email'].'; ';
}

?>

[Canman2005]

Hi

 

So how can I define that so that if I use

 

$emails

 

within a INSERT statement, it would print

 

email@domain.com; name@domain.com;

 

Does that make sense?

 

Thanks