Help extracting information from array

[Max_CR]

Hi,

I am trying to display an array in PHP. The array is generated using information taken from the database. As of now, the information is displayed using print_r. The information displayed is:

Array ( [0] => [e-mail] [1] => [e-mail] [2] => [e-mail] [3] => [e-mail] ) 

I would like to only display the email addresses on my page. In between each email address, I would like a ";" then a space. So I would like it to display like this:

[e-mail]; [e-mail]; [e-mail]; [e-mail]; 

I have been messing with this for a long time but cannot figure it out. The code I am using is:

		$sql = "SELECT user_email
			FROM " . USERS_TABLE . "
			WHERE mailing_list = 1
			ORDER BY user_id";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not obtain extra user info type table', '', __LINE__, __FILE__, $sql);
		}
		$ndetails_xuinfo_types=0;
		while ($row = $db->sql_fetchrow($result))
		{
			$mailing_list_results[] = $row['user_email'];
			$ndetails_xuinfo_types++;
		}
		$db->sql_freeresult($result);
		print_r($mailing_list_results);

Thank you!!

[dagon]

replace

$mailing_list_results[] = $row['user_email'];

with

$mailing_list_results.=$row['user_email'].'; ';

//snip

echo $mailing_list_results;

no need for the array in the first place.

[bradgrafelman]

You also might want to look at the documentation for whichever DB class you're using as many provide a "fetchAll" type of method, in which case you could simply fetch all of the rows (presumably as an array) and use [man]implode/man to join the results together using a semicolon as the separator.