Insert results from SELECT * query into an e-mail

[aussieguy]

I would like to retrieve data (multiple rows) from a table and then put the results into a e-mail message

Something like this?

SELECT* FROM orders WHERE x = y
(I expect at least 3-15 rows to be retrieved)

then have the results entered into $emailmessage

The email message must have text first Hello blah blah blah then the results from the query..

$emailmessage ="hello\tthis\tis\ta\tmessage\n\n(Results go here)";

$to = "$someone";
$subject = "Your results";
$mailheaders = "Wrom: OHMKHJYFMYXOEAIJJPHSCRT
$mailheaders .= "Reply-To: [e-mail]\n\n";
mail($to, $subject, $emailmessage, $mailheaders);

OR is there a better way to do this than using the mail() ??

Thanks

[TTT]

$foo = mysql_fetch_array($yourQueryName);

$message = "Hello\n";

for($a=0;$a<count($foo);$a++) {
$message = $message.$foo[$a]."\n";

}

[aussieguy]

thanks TT but the code you suggested only inserted the first record found to the e-mail

plus it put each field on a new line

I was looking to dosomething like this

E-mail message would be formatted something like this

Hello user this is your selection for your reference.

Field1, Field2, Field3, Field4, (from first row)
Field1, Field2, Field3, Field4, (from second row)
(Untill all rows are inserted)

if this not possible then I will just put a link into the e-mail message where the user can retieve his/her data in a web page, Not the best solution but that is easier than trying to put the rows in the e-mail.

[TheIceman5]

piece of piss, something along these lines.

$message = "Hello\n";

while($abcd = mysql_fetch_array($yourQueryName)) {
$message = $message.$abcd['fieldname'].", ".$abcd['fieldname2'].", ".$abcd['fieldname3']."\n";

}

modify that to suit your needs.

[aussieguy]

Thanx Iceman it worked straight out of the box

:p