[RESOLVED] mail () HELP

MacH4ck

I cannot figure out how to do this and if anyone can help I would appreciate it.

Here is what I would like to do. I want to grab the email address from all of my registered members and be able to send an email to all of them. I would like to select email from members table bring them into a form where I can type in a subject, type my message and click a submit button to send the email. I know how to query the emails, I know how to create the form, and I know how to use mail (), but I don't know how to incorporate all that together.

Thanks in advance.

nickadeemus2002

http://www.phplist.com/

MacH4ck

Thanks but I don't want to have to use another program. There has got to be a way to do what I would like.

nickadeemus2002

a few suggestions:

1.) create the email message template form
2.) create the form with your action attribute set to execute your mail() script on the same page as the form, or on a second page.
3.) after the submit button is pressed, query your database table for registered users and loop through each record.
4.) within the loop, make sure variables from your email template are nested there to represent your message content, and have the mail() execute after those variables are set.

MacH4ck

Thanks for the reply back. I am still very new to this so some of the things you said I don't have a clue on what you meant. But I will research it and see if I can figure it out.

Thanks again.

nickadeemus2002

if you had some code, maybe i could help you more. do you have the form? if so, post it and we can go from there. if you post it, i will help.

MacH4ck

No not really, I write it and it does not work the way I think it should then I delete and start over. I have a very small amount that I started on again. I can post that but I have not got the form recreated again.

?php
include "open_session.php";
if (!isset($mainfile)) include "mainfile.php";
include "config.php";

include "header.php";
$index =0;

$query = "SELECT email FROM members";
$result = mysql_query ($query);

while ($row = mysql_fetch_array($result)) {
echo "{$row['email']} <br>";
}

?>
Thanks

nickadeemus2002

please put your code in php tags so its easier to read. is should look like this:

<?php
include "open_session.php";
if (!isset($mainfile)) include "mainfile.php";
include "config.php";

include "header.php";
$index =0;

$query = "SELECT email FROM members";
$result = mysql_query ($query);

while ($row = mysql_fetch_array($result)) {
echo "{$row['email']} <br>";
}


?>

a couple of things here:
1.) there is no form here that will accept your message input.

2.) what does 'mainfile.php' do?
3.) is this script part of a bigger app using session data?
4.) this script will print the email address of all your members to the screen. thats all that happens here.

BTW,

your form should look something like what "Houdini" posted in this thread:

http://www.phpbuilder.com/board/showthread.php?t=10336446

MacH4ck

Sorry about not posting my code in tags.

Yes this is a small part of a bigger script. The code that I posted was what I was recreating. I know the emails are just showing on the screen and nothing else, I guess (probably wrong) but I was doing a little bit at a time just to see how everything works so I can try a figure out what it is I am trying to do.

I do appreciate all you help though

MacH4ck

ok, i have been working more on my mail issue, but once again I hit the road block. After I SELECT email FROM members, How do I take that information and use that in the

mail () function. Do I need to create a variable called $email and if so would look something like mail($email, $subject, $message) and if so what would the email variable contain, the information from mysql_query?

Thanks

MacH4ck

Hey I figured it out. Thanks everyone for your help. I could not figure out how to grab my query result and get it into the mail() function. Here is what I came up with.


$query = "SELECT email FROM members";;
$result = mysql_query ($query);
$row = mysql_fetch_array($result);

$email = $row['email'];

Then for the mail() function


<?php                                                                                                                

mail($email, $_POST['subject'], $_POST['message'], 'FROM:admin@yoursite.com');                                      

include "footer.php";                                                                                                

?>

bradgrafelman

Don't forget to mark this thread resolved.

MacH4ck

I thought it was solved but it is not. It is only grabbing the first members email in the database and sending an email to him. Also, as soon as I go to my mail form it sends an email even without me typing in a subject or a message even though I am checking for that. still need some help please.

roscor

try this It get the full email results from the database,

<?

          include("dbinfo.inc.php");//database connect

$conn = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($database,$conn) or die(mysql_error());
$result = mysql_query("SELECT email, COUNT(email) FROM members GROUP BY email");

echo '<table>';
while ($row = mysql_fetch_assoc($result)) {
    echo '<tr><td>' . $row['email'] . '</td><td></tr>';

}
echo '</table>'; 
?>

Hope this helps,

roscor
Hope this o