Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

fjwolz19 · 04-09-2008, 02:16 PM

I have a MySQL Database with a table containing a column for email addresses. I would like to create a string to use in php that lists all the addresses that are in that column seperated by commas. Is there an easy way to do this, either by using a loop in php or some command in MySQL?
_____________________________________________
This is what I want to get (with generic emails listed here).....

email.address@whatever.com,fake@blah...ng@e mail.com
_____________________________________________
This is what I have

recipients table
email
emailaddress@whatever.com
fake@blah.com
testing@email.com
_____________________________________________

Thank you in advance for any assistance you can give me.

04-09-2008, 02:16 PM	#1 (permalink)
fjwolz19 Junior Member Join Date: Apr 2008 Posts: 1	Multiple Rows into One String I have a MySQL Database with a table containing a column for email addresses. I would like to create a string to use in php that lists all the addresses that are in that column seperated by commas. Is there an easy way to do this, either by using a loop in php or some command in MySQL? _____________________________________________ This is what I want to get (with generic emails listed here)..... email.address@whatever.com,fake@blah...ng@e mail.com _____________________________________________ This is what I have recipients table email emailaddress@whatever.com fake@blah.com testing@email.com _____________________________________________ Thank you in advance for any assistance you can give me.