send mail based on selection from dynamic drop down menu

[brancook]

Hi all,

First post here. I'm pulling my hair out on this one. I'm trying to send emails to different users based on what is selected from a dynamic drop down list. Here is what I have that doesn't work:

<?php
$to = "[e-mail]";
$subject = "current email test";
$message = "New RMA FORM FOR $rma";
$id = $_POST['status']; 
$query = "select id from mytablename where id='$id'";
$result = mysql_query($query);


if (mysql_num_rows($result)==1){
	mail($to, $subject, $message);
}

?>

If I change my if statement to:

if (mysql_num_rows($result)==''){

I do get the email but I get the email when I go to the page or just refresh it not based on any kind of selection.

anyone have any idea what i need to do?
Thanks!!!

[devinemke]

$result = mysql_query("SELECT id FROM mytablename WHERE id = '" . $_POST['status'] . "'") or exit(mysql_error());
if (mysql_num_rows($result))
{
	$to = '[e-mail]';
	$subject = 'current email test';
	$message = "New RMA FORM FOR $rma";
	$from = 'From: brancook <[e-mail]>';
	mail($to, $subject, $message, $from) or exit('mail failed');
} 
else
{
	echo 'no rows found matching that ID';
}

[brancook]

This didn't seem to work. I'm starting to wondering if my select statement needs to be tweaked. The table I'm trying to get data from is part of a relational database. The status table is part of the dropbox. Here are is my code from the dynamic drop down menu and the table structure:

echo '<br /><br />';
echo '<select name="status">'."\n";
echo '<option value="none">Select unit status&nbsp;&nbsp;&nbsp;</option>'."\n";
$status_name = mysql_query('SELECT * FROM status ORDER BY id');while ($status = mysql_fetch_array($status_name, MYSQL_ASSOC)){
echo	'<option value="'.$status['id'].'"';
	if($record_data['ref_status_id']==$status['id']) print " selected=\"selected\" "; 
echo '>'.$status['status_name']."</option>\n";

}
echo '</select>'."<br />\n";

main table name: dropbox
columns: id, filename, mimetype, date, filedata, ref_status_id, ref_rma_id, ref_categories_id

table name: status
columns: id, status_name

table name: categories
columns: id, category

table name: rma
columns: id, rma_number