automatic emails

based on selection from dynamic dropdow menu

[brancook]

I want to send automatic emails based on a selection from a dynamic dropdox menu once it is selected and submitted. The dropdown menu references an id from a table. What would my if statement look like? So if an id is selected a user is notified via email.

[jatar_k]

you could just select it from the db using the id that the user selected

[brancook]

I'm having some trouble figuring out what $message would look like. Do I need to make another sql statement?

[jatar_k]

for the status?

[brancook]

Yes, for the status to insert the status name from the option value instead of the id. So I'd want the status to read Status = "Estimate" in the email instead of Status = "2".

[jatar_k]

just add a

$q = "select status_name FROM status where id=" . $id;

and put the value in the message

[brancook]

I'm still just getting the id displayed...

[jatar_k]

did you execute the query and then get the value back from mysql?

if so you should have the status_name in some variable you named and then you can put that into the message.

if you did that and it isn't working then show me the code

[brancook]

This is my latest try:

$id = $_POST['status'];
$ok = @mysql_query($sql);
if (!$ok) {
exit('Database error storing file: ' . mysql_error());
} elseif ($ok) {
$to = '';
if ($id == 2 ¦¦ $id == 10) $to = '[e-mail]';
else $to = '[e-mail]';
$q = "select status.status_name FROM status where status.status_name=" . $id;
if ($q) $message = 'status_name';
$subject = "current email test";
mail($to, $subject, $message);
echo('File uploaded successfully!<br />example has been notified of your upload and you will recieve an estimate soon<br /><a href="http://www.example.com/sta_fileshare/sta_rma_upload.php">Back to STA File Uploader</a>');
}
}

I guess I really just don't see where to pull the name and how to relate it to it's id. It seems like it should be simple but I just don't see it.

[edited by: jatar_k at 9:33 pm (utc) on Oct. 31, 2007]
[edit reason] examplified [/edit]

[jatar_k]

you'll need to send the query to the db

$id = $_POST['status'];
$ok = @mysql_query($sql);
if (!$ok) {
exit('Database error storing file: ' . mysql_error());
} elseif ($ok) {
$to = '';
$message = '';
if ($id == 2 ¦¦ $id == 10) $to = '[e-mail]';
else $to = '[e-mail]';
$q = "select status_name FROM status where status_name=" . $id;
$query = mysql_query($q);
if ($row = mysql_fetch_array($query)) {
$message .= $row['status_name'];
}
$subject = "current email test";
mail($to, $subject, $message);
echo('File uploaded successfully!<br />example has been notified of your upload and you will recieve an estimate soon<br /><a href="http://www.example.com/sta_fileshare/sta_rma_upload.php">Back to STA File Uploader</a>');
}
}

that should work, you can then append anything to message by using

$message .= 'next value here';

[brancook]

Thanks, I'll give that a try...

[brancook]

Hey looks like this works, I did have to tweak the $q statement to look like this:

$q = "select status.status_name, status.id FROM status where id=" .$id;

Thanks for all your help!