correct usage of the while loop...need help please

Dev Articles Community Forums Sponsor:

February 11th, 2003, 07:17 PM

Vasarab69

Goldmember

Join Date: Nov 2002

Posts: 71

Time spent in forums: 5 m 25 sec
Reputation Power: 7

please help: using the while loop with commas

hello-

i'm working on a script which a monthly newsletter can be sent from the browser to all of the users which selected to get the newsletter when they registered (database table named 'newsletter' with a value of either 'Yes' or 'No')...i have no clue how to get the info from the db in comma-like form...so that it includes the address like "foo1@bar.com, f00foo@bar-bie.com, foo223@bar.com" ETC., but not having the last address have a comma after it.

how could i use the while loop (im guessing) to do this? thanks!

__________________
-Alexander

Last edited by Vasarab69 : February 11th, 2003 at 10:04 PM.

February 12th, 2003, 03:33 AM

vlasblom

Junior Member

Join Date: Oct 2002

Location: Netherlands

Posts: 14

Time spent in forums: 8 m 45 sec
Reputation Power: 0

Alexander,

Using the rtrim function will do the trick.

Depends how you extract the records from your database, but I'm thinking of something looking like this:

PHP Code:


		
			
 $strAddress = "";

$strSQL = "SELECT email FROM newsletter WHERE selected = 'Yes'";

$query = mysql_query($strSQL) or die(mysql_error());

if(mysql_num_rows($query) > 0)

{

    // Concatenate all email addresses into a single address string

    while($result = mysql_fetch_array($query))

    {

         $strAddress .= "$result[email], ";

    }

     

     // Remove last comma and space

     rtrim( $strAddress, ", " );

}

Regards,
Arjon

Viewing: Dev Articles Community Forums > Programming > General Programming Help > correct usage of the while loop...need help please

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump