email message body from mysql data

[canajien]

I need to have a php script pull data from a mysql table and send it
in the body of an email

I know I can get the script to display information in the browser by
doing this:

$i=0;
while ($i < $num) {

$who=mysql_resu lt($result,$i," who");
$where=mysql_re sult($result,$i ,"where");

echo "<b>$who</b><br>$where<hr ><br>";

$i++;
}
and the output will look like:

john
toronto
If I use:

$message = "message text goes here";

I can get an email where the message reads "message text goes here"
how do I replace "message text goes here" with the information from
the mysql table

[Michael Austin]

ca******@gmail. com wrote:

I need to have a php script pull data from a mysql table and send it
in the body of an email

I know I can get the script to display information in the browser by
doing this:

$i=0;
while ($i < $num) {

$who=mysql_resu lt($result,$i," who");
$where=mysql_re sult($result,$i ,"where");

echo "<b>$who</b><br>$where<hr ><br>";

$i++;
}
and the output will look like:

john
toronto
If I use:

$message = "message text goes here";

I can get an email where the message reads "message text goes here"
how do I replace "message text goes here" with the information from
the mysql table

you are kidding right?

How about $message = $who."\n".$wher e;

[Paul Lautman]

ca******@gmail. com wrote:

>I need to have a php script pull data from a mysql table and send it
in the body of an email

I know I can get the script to display information in the browser by
doing this:

$i=0;
while ($i < $num) {

$who=mysql_resu lt($result,$i," who");
$where=mysql_re sult($result,$i ,"where");

echo "<b>$who</b><br>$where<hr ><br>";

$i++;
}
and the output will look like:

john
toronto
If I use:

$message = "message text goes here";

I can get an email where the message reads "message text goes here"
how do I replace "message text goes here" with the information from
the mysql table

We cannot tell you as there is insufficient information here to tell where
that data is stored.

[canajien]

On Mar 20, 6:32 pm, Michael Austin <maus...@firstd basource.comwro te:

canaj...@gmail. com wrote:

I need to have a php script pull data from a mysql table and send it
in the body of an email

I know I can get the script to display information in the browser by
doing this:

$i=0;
while ($i < $num) {

$who=mysql_resu lt($result,$i," who");
$where=mysql_re sult($result,$i ,"where");

echo "<b>$who</b><br>$where<hr ><br>";

$i++;
}
and the output will look like:

john
toronto

If I use:

$message = "message text goes here";

I can get an email where the message reads "message text goes here"

how do I replace "message text goes here" with the information from
the mysql table

you are kidding right?

How about $message = $who."\n".$wher e;

unfortunately I'm not kidding, we have a form that sends to a
database, I tried to get to get it to send an email at the time the
form is submitted when a certain condition is met but no-one seems to
know how to do it, so the next best thing was to write a php script
and run a cron job with wget to search the database once a day looking
for entries that meet the criteria and send the email to the people
who need it

tried your suggestion, but it didn't work :( no email gets sent, but
it does give me some ideas

thanks

[Jerry Stuckle]

ca******@gmail. com wrote:

On Mar 20, 6:32 pm, Michael Austin <maus...@firstd basource.comwro te:

>canaj...@gmail .com wrote:

>>I need to have a php script pull data from a mysql table and send it
in the body of an email
I know I can get the script to display information in the browser by
doing this:
$i=0;
while ($i < $num) {
$who=mysql_re sult($result,$i ,"who");
$where=mysql_ result($result, $i,"where");
echo "<b>$who</b><br>$where<hr ><br>";
$i++;
}
and the output will look like:
john
toronto
If I use:
$message = "message text goes here";
I can get an email where the message reads "message text goes here"
how do I replace "message text goes here" with the information from
the mysql table

you are kidding right?

How about $message = $who."\n".$wher e;

unfortunately I'm not kidding, we have a form that sends to a
database, I tried to get to get it to send an email at the time the
form is submitted when a certain condition is met but no-one seems to
know how to do it, so the next best thing was to write a php script
and run a cron job with wget to search the database once a day looking
for entries that meet the criteria and send the email to the people
who need it

Get someone competent to do your scripting. It should be a pretty minor
matter to add this to the script which stores data in the database.

tried your suggestion, but it didn't work :( no email gets sent, but
it does give me some ideas

thanks

It's not that hard in many cases, but can be very difficult in others.
It depends mainly on how your email server is set up.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===