how to use mail function with query results

[Anon]

I would like the mail function to send an
email with the results of a query in
the body of the message. So far I only
understand how to send the values of variables passed from a form.

The code looks like this so far:

$result = mysql_query ("select * from workorder where dba='TechMarin'");
if ($row = mysql_fetch_array($result))
{
print "HELLO";
print $row["id"];
print $row["date"];
mail("[e-mail]","Email from form","$username\n$password\n$dba\n$id\n","From:[e-mail]");
}
?>

but $id is blank instead of containing the
value from the field.

Please speak simply, I am still stupid :-)

Thanks for any hints !!

[Anon]

Hi!! Thats because yo must to call the field like this:

mail(\"[e-mail]\",\"Email from form\",\"$username\n$password\n$dba\n\" . $row[\"id\"] . \"\n\",\"From:[e-mail]\");

HTH
inK

[Anon]

Thanks for the tip ! - while the exact format
did not work, the $row["id"] did exactly
what I needed.

I also added a

do {
} while($row = mysql_fetch_array($result));

between the mail function to handle multiple
records being returned.

Now of course I would like to get all the
records sent in a single email. As it is
now an email is sent for each record that
matches the search criteria.

Thanks again, your solution got me
working !!

[Anon]

Hi
I have the same problem!

Have you found a solution, on how to get all the records sent in a single email yet?

Jacob

[Anon]

Hi again!!!
Well, I think that the best solution it's to concat everything in a variable, and, when the search ends, send that variable in the mail.
For example:

<?
while($row = mysql_fetch_array()) {
$mail_msg = $mail_msg + "\n" + $row['id'];
}

mail($to, $subject, $data);
?>

HTH
Happy new year!!!

inkel

ps: if you want, reach me at my email address ([e-mail])

[Anon]

Well that didn't work, anything else???

[Anon]

use . instead of +

Worked for me...

[Anon]

Cheers for that, i solved it 5 mins later with the following: -

$lnum = mysql_num_rows($vtable);
do{
$pc = mysql_fetch_row($vtable);
$mail_message .= "$pc[0]\t$pc[1]\t$pc[2]\t$pc[3]\t$pc[4]$pc[5]\t$pc[6]\n";
echo("$mail_message");
$test = $test + 1;
}while($test != $lnum);