Does anyone feel like a challenge??

[kpowning]

I have a problem with the email script of this .php code. When the page loads, it automatically sends a blank email with the form variables in it. Then when the customer fills out the form fields and presses submit, I get another email, but with the information... Why is this. I have honestly tried everything and no one can seem to help me.. Below is the .php script on the page and in the next post is the form variable in html...

<?php require_once('Connections/emall.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "Contact")) {
  $insertSQL = sprintf("INSERT INTO nvcontact (Full_Name, Email_Address, Comments, `Business Name`, `Phone Number`) VALUES (%s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['Fname'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Eaddress'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Comment'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Bname'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['Phone'], "text"));

  mysql_select_db($database_emall, $emall);
  $Result1 = mysql_query($insertSQL, $emall) or die(mysql_error());

  $insertGoTo = "/Email/Confirm.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mail("[e-mail]", "Nevada Matters Comment", "The following has been submitted by a customer at: [url]www.nevadamatters.com.\r\n\r\n[/url]
-------------------------------------------------------------------------------------------------------------------------------------------------\r\n\r\n\r\n\r\n
Customers Name: $Fname\r\n
Businesses Name: $Bname\r\n
Email Address: $Eaddress\r\n
Phone Number: $Phone\r\n
Comments: $Comment\r\n\r\n
--------------------------------------------------------------------------------------------------------------------------------------------------\r\n\r\n",
"From: [email][e-mail][/email]\r\n".
"Reply-To: [email][e-mail][/email]\r\n".
"Return-Path: [email][e-mail][/email]\r\n");
?>

[kpowning]

<form action="<?php echo $editFormAction; ?>" method="POST" name="Contact" id="Contact" style="margin-bottom: 0" onSubmit="MM_validateForm('Full_Name:','','R','Email_Address:','','RisEmail');return document.MM_returnValue">
<p><strong>Full Name:</strong>
<input name="Fname" type="text" id="Fname">
</p>
<p> <strong>Business Name:</strong> <strong><u>
<input name="Bname" type="text" id="Bname">
</u></strong></p>
<p> <strong>Email Address:</strong>
<input name="Eaddress" type="text" id="Eaddress">
</p>
<p> <strong>Phone #:</strong>
<input name="Phone" type="text" id="Phone" size="12">
</p>
<p align="center"><strong><u> Comments and/or suggestions:</u></strong></p>
<p align="center">
<textarea name="Comment" cols="50" id="Comment"></textarea>
</p>
<p align="center">
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Reset">
</p>

    <input type="hidden" name="MM_insert" value="Contact">
  </form>

[diego25]

Are both codes in the same script? If they are, then when the script loads the first time, it will send an e-mail because the mail() function is not inside an if statement or anything. So just add an if statement checking that the form has been submitted...

Diego

[kpowning]

How can I make an if statement for this to work? Yes, both codes are on the same page, but I have no idea how to actually write an if statement. I would really appreciate your help, if you have the time... I'm very sorry, for asking you to help me on this one...

[diego25]

If the form has been submitted, then the form field Fname would be in the $_POST array, right? So you could check for that.

e.g.

if (isset($_POST['Fname'])) {
mail(...);
}

If you're using PHP before 4.1.0, use $HTTP_POST_VARS instead of $_POST.

Diego

[kpowning]

Man.... Thank you soooo much.. I don't think you understand how long I have been messing with this thing..... I really appreciate your help on this😃 😃 😃 😃 ........It did work for me and thanks again sooo very much.....

Take care...