Re: [NEWBIE] Trying to combine array into one string

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Use implode:

http://nl2.php.net/manual/en/function.implode.php



On 15 Feb 2005, at 16:37, Dave wrote:

PHP General,

The Situation:
I'm retrieving some email addresses from a database. I want to be able assemble all the addresses into one string that I can use in the mail() command. At no time should there ever be more than about 5 email addresses collected from the database. I want all addresses to appear in the "To:" field so everyone receiving the email will know who else has a copy.


The Problem:
I can't quite figure out how to take the results of the mysql_query() and assemble them into a string. In my experiments so far, I either get a "mysql_data_seek(): Offset 0 is invalid for MySQL result index" error, or my mail function sends to a blank address.


What I've Tried So Far:
My own code is obviously flawed in syntax in logic, so I searched the manual and this list's archives under the terms "array", "concatenate", "convert", "append" and "string" in various combinations. However, while I learned some interesting tips on a variety of topics, I suspect I'm missing some essential description that will lead me to the command I need.


The Question:
How do I take the contents of an array and turn them into a single string?


For Reference:
Here is the code I have. I know it's flawed, but hopefully it will give an indication of what I'm trying to achieve:
--code--
$tantoQuery = "SELECT forum_members.emailAddress AS email FROM forum_members, event_tanto WHERE forum_members.ID_MEMBER = event_tanto.tanto AND event_tanto.event ='" . $show . "'";


   $tantoResult = mysql_query($tantoQuery);

   while ($tantoData = mysql_fetch_array($tantoResult))
   {
       $tantoEmail = $tantoEmail . "," . $tantoData;
   }

   mail($tantoEmail, $subject, $mailcontent, $addHeaders);
--code--

   Any help would be much appreciated.

--
Dave Gutteridge
dave@xxxxxxxxxxxxxxx
Tokyo Comedy Store
http://www.tokyocomedy.com/english/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux