Mail Function Help!

Anon

I have everything working the way I want except one little thing.

mail(
"jake@pixelot.com",
"Brochures (webpage)",
"Name: $name\n E-mail: $email\n\n Address: $address\n : $city, $state $zip

while ($query_data = mysql_fetch_object($result)) {
\n $query_data->name
}

",
"From: $email");

header("Location: brochures_01.php");

Theres my code. And I have some brochures in a database so its all dynamic and I need it to send me those brochures in an e-mail with the value.

Maybe this will help. Here is the page http://64.177.187.63/brochures_01.php

So if anyone could help. I would greatly appriciate it. And I do have the connection and everything in there. Just didn't want to show everyone. Thanks.

Anon

erm, I just tried it and it works fine, well, seemed to, though I haven't got the mail yet, that takes a few mins from my own php scripts as well.

What exactly is the problem?

toma42

you can't nest a while in a function. Move the while to the outside and call the mail() multiple times.

Anon

Thank you very much Tom. I don't know why I didn't try that. I guess I shouldn't stay up so late then maybe I can think straight 🙂
Thanks again!

Anon

But... if I put the while outside the mail function it will send me mail however many times there is a brochure.

Anyone else have any ideas?

Anon

Okay, I don't know exactly what your trying to do cause I didn't get a reply to that one, how about this though...

create a table
submit is clicked
mail information

Try something like this...

<FORM ACTION="<?php echo($PHP_SELF); ?>" METHOD=POST>
<table border="0" cellspacing="0" cellborder="0">
<TR><TD bgcolor=fd4d1f9">Name</TD><TD><INPUT TYPE="text" NAME="day" SIZE="20" MAXLENGTH="20"></TD>
<TR><TD bgcolor=fd4d1f9">E-Mail</TD><TD><INPUT TYPE="text" NAME="month" SIZE="20" MAXLENGTH="30"></TD>
<TR><TD bgcolor=fd4d1f9">Address</TD><TD><INPUT TYPE="text" NAME="year" SIZE="30" MAXLENGTH="50"></TD>
</table>
<br>
<INPUT TYPE=SUBMIT NAME="submit" VALUE="SUBMIT">
</FORM>

<?php
if ($submit) {

mail("enteryouaddresshere", "$name", "address"
"From: $e_mail\nReply-To: $e_mail");
echo "Mail sent!";
}
?>

Something like that should work anyways, they click send, you get the mail.

Anon

Okay, I am going to try and describe this one more time. Its a little confusing.

I have a databaes with brochures in it. And I made a feild that is called publish. So in my sql statement on

http://64.177.187.63/brochures_01.php I say SELECT * FROM brochures WHERE publish = 1

And that is what spits out the brochures onto the page. And I submit the form and do a mail function. Everything works great. The mail sends iand everything. But, I some how need to get those brochures to send with it. So I was trying to do a "while" in my mail function to get all the brochures with pubish = 1 to get sent to me. Thats where I am stuck. Here is what I was trying.

$db = mysql_connect("localhost", "*", "");
mysql_select_db("********",$db);

$result = mysql_query("SELECT * FROM brochures WHERE publish = '1' ORDER BY name", $db);

mail("myemail", "Brochures (webpage)", "Brochure Request Form\n-------------------------------------\n\n Name: $name\n E-mail: $email\n\nAddress: $address\n : $city, $state $zip\n\n

while ($query_data = mysql_fetch_object($result)) {
\n\n$query_data->name;
}

", "From: $email");

header("Location: brochures_01.php");

Thanks again!