Hello Maxim,
This works great except that it does,t print the email if I take the
'<' '>' off then it does but I need those < >
Tuesday, May 15, 2001, 7:58:28 PM, you wrote:
Maxim Maletsky> Try this instead:
Maxim Maletsky> $sql = "
Maxim Maletsky> SELECT
Maxim Maletsky> CONCAT(fname, ' ', lname, '<', email, '>') AS str_email
Maxim Maletsky> FROM
Maxim Maletsky> customers
Maxim Maletsky> ";
Maxim Maletsky> and then the rest of your code..
Maxim Maletsky> Sincerely,
Maxim Maletsky> Maxim Maletsky
Maxim Maletsky> Founder, Chief Developer
Maxim Maletsky> PHPBeginner.com (Where PHP Begins)
Maxim Maletsky> [EMAIL PROTECTED]
Maxim Maletsky> www.phpbeginner.com
Maxim Maletsky> -----Original Message-----
Maxim Maletsky> From: Richard Kurth [mailto:[EMAIL PROTECTED]]
Maxim Maletsky> Sent: Wednesday, May 16, 2001 10:49 AM
Maxim Maletsky> To: [EMAIL PROTECTED]
Maxim Maletsky> Subject: [PHP] Need a little help with array
Maxim Maletsky> I am trying to get the first name and Last name plus the email
Maxim Maletsky> address out of the database in a format like this
Maxim Maletsky> Richard Kurth<[EMAIL PROTECTED]>;Richard
Maxim Maletsky> Kurth<[EMAIL PROTECTED]>
Maxim Maletsky> so I can put it in the BCC section of a mail all customer program
Maxim Maletsky> What I have below works for getting the email out but I can't
Maxim Maletsky> figure out how to get the rest out all together
Maxim Maletsky> $sql = "SELECT email,fname,lname FROM customers";
Maxim Maletsky> $result = mysql_query($sql);
Maxim Maletsky> $recipient = array();
Maxim Maletsky> while ($myrow = mysql_fetch_array($result))
Maxim Maletsky> $recipient[] = $myrow["email"];
Maxim Maletsky> $recipient_list = implode(",", $recipient);
Maxim Maletsky> Best regards,
Maxim Maletsky> Richard
Maxim Maletsky> mailto:[EMAIL PROTECTED]
--
Best regards,
Richard
mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
