[RESOLVED] laying out results from query php

[steveDD]

Hi,

my next question (formu is really helping with my project thanks), is I have a list of emails in my database and I want to create a page say emails.php and for it to display the emails [email][e-mail],[e-mail][/email],

so basically divide them all with a , so I can add them directly into my outlook. Is there a way I can do this by code what I have so far...

<?php

$conn = mysql_connect("localhost", "username", "password");
mysql_select_db("mydatabase", $conn);

$result = mysql_query("SELECT myemail FROM emails")
or die(mysql_error());

?>

[m_tt]

You could save all the emails to an array, then implode.

$emails = array( );
while( $row = mysql_fetch_assoc( $result ) )
{
	$emails[] = $row['myemail'];
}
echo implode( ",", $emails );

[steveDD]

thanks that is bringing back the emails but there is a few errors with layout.
One problem is emails that have - in them are being cut and then its goes on to a new line with the next address.

Also is there a way to stop it going on and on so once it hits the edge of the page it starts a new line?

Steve

[m_tt]

Can't you just use an HTML table or CSS to contain the addresses?

[steveDD]

yeh I have put it in a html table but the addresses just make it widder?

Also it doesn't seem to like the - part of peoples email address?

Steve

[m_tt]

Since the emails are one long string, you will have to either add a space after each comma (in the implode function) or create your own wrapper function.

[steveDD]

fixed, table width was on 100% lol, sorry for the stupid question... resolved.