Simon
|
| Posted: 05/14/2003, 6:49 AM |
|
Hi all ccs users,
I would like to be able to send out a dump of a db table containing the
latest questions & answers from a discussion group.
I have a db tabel with emails of members that want the latest q&a's, but
how do i get CCS to mail the contents of the q&a table to all users in
the members table. ?
I know how to setup CCS to send emails, but how do i populate the
$message with the content of the db table, and how do i send i to all
users ??
I use MySQL and PHP.
- Simon
|
|
|
 |
Simon
|
| Posted: 05/15/2003, 1:23 AM |
|
In article <MPG.192c676269d9f4c3989683@news.codecharge.com>,na@na.na
says...
> Hi all ccs users,
>
> I would like to be able to send out a dump of a db table containing the
> latest questions & answers from a discussion group.
>
> I have a db tabel with emails of members that want the latest q&a's, but
> how do i get CCS to mail the contents of the q&a table to all users in
> the members table. ?
>
> I know how to setup CCS to send emails, but how do i populate the
> $message with the content of the db table, and how do i send i to all
> users ??
>
> I use MySQL and PHP.
>
> - Simon
>
Well i have found a solution:
So just for the record......
$SQL = "your sql query here - use the visual builder to create it";
$db = new clsDBSN();
$db->query($SQL);
$subject = "Test";
$message = "blaaaaaaaaa";
$from = "Me";
$additional_headers = "From: $from\n" .
"Reply-To:foo@bar.dk".
"MIME-Version: 1.0\r\n" .
"Content-type: text/html; charset=iso-8859-1\r\n" .
while ($db->next_record())
{
$to = $db->f("the name of the email field in your query or db");
mail($to, $subject, $message, $additional_headers);
}
|
|
|
|
GRQNET
|
| Posted: 05/29/2003, 9:04 PM |
|
Does anyone have this code in ASP?
I have a list I would like to send emails to.
Thanks!!
"Simon" <na@na.na> wrote in message
news:MPG.192d6c8fea875219989684@news.codecharge.com...
> In article <MPG.192c676269d9f4c3989683@news.codecharge.com>,na@na.na
> says...
> > Hi all ccs users,
> >
> > I would like to be able to send out a dump of a db table containing the
> > latest questions & answers from a discussion group.
> >
> > I have a db tabel with emails of members that want the latest q&a's, but
> > how do i get CCS to mail the contents of the q&a table to all users in
> > the members table. ?
> >
> > I know how to setup CCS to send emails, but how do i populate the
> > $message with the content of the db table, and how do i send i to all
> > users ??
> >
> > I use MySQL and PHP.
> >
> > - Simon
> >
> Well i have found a solution:
> So just for the record......
>
> $SQL = "your sql query here - use the visual builder to create it";
>
> $db = new clsDBSN();
> $db->query($SQL);
>
> $subject = "Test";
> $message = "blaaaaaaaaa";
> $from = "Me";
> $additional_headers = "From: $from\n" .
> "Reply-To:foo@bar.dk".
> "MIME-Version: 1.0\r\n" .
> "Content-type: text/html; charset=iso-8859-1\r\n" .
>
> while ($db->next_record())
> {
> $to = $db->f("the name of the email field in your query or db");
> mail($to, $subject, $message, $additional_headers);
> }
|
|
|
|
|
