Convert output of mysql fetch array to a $variable

[drooh]

I am making a simple system that views email addresses that I have stored for an email newsletter. I am having my php list them out in groups of 10 adding a semicolon at the end of each address. This way I can copy & paste them right into my email composition.

The problem I am having is that I want to remove the very last semicolon becuase what I have is outputting something like this

randomnameemailcom; randomguyemailcom; randomgirlemailcom;

and I need it to output like this

randomnameemailcom; randomguyemailcom; randomgirlemailcom

here is some of my php code, i know that i need to probably use the rtrim() function but Im just not sure how to emplement it...

while(list($val) = mysql_fetch_array($result))
{
$text = "$val; ";
};

$text = rtrim($text, '; ');
echo $text;

how would I make the output result into a single variable in which I could then clip the final semicolon off of?

[dreamcatcher]

$text = substr_replace [uk2.php.net]($text,'',-1);

dc

[drooh]

that seems to work but I still am having trouble understanding how to get what is output by the array into a single variable. meaning in my example, all the emails are listed out with a semicolon after them & I want to just clip off the very last semicolon of the string..?

does this make sense?

in the example I have it only echos one email address, not all of them.

[dreamcatcher]

Firstly, get your data into an array like this:

$text = array();
$string = '';
while(list($val) = mysql_fetch_array($result))
{
$text[] = $val;
};

Then do this:

if (!empty($text))
{
$string = implode(",",$text);
echo $string;
}

Using implode you won`t need to strip the last comma.

dc

[drooh]

awesome, not sure i know how you did it or understand why it works but it does, thank you!

[dreamcatcher]

You`re welcome. Implode converts data in an array to a delimited string. More info here [uk2.php.net]

dc

[drooh]

I am having a problem now with this script, it seems that the fields in the db that are empty are causing problems. is there a way to populate a list of only fields that contain text? right now Im getting an output similar to this.

, email[at]email[dot]com, , , email[at]email[dot]com, email[at]email[dot]com, ,

[dreamcatcher]

No problem drooh, change this:

$text[] = $val;

to this:

if ($val)
{
$text[] = $val;
}

dc