I am a newbie, really need your help. I've been working on this for 2 days and can't get it to work correctly. I have a form that I want to submit to the database "New Lead" form. I am using the submodal feature for the customer notes. For some reason, the data is not inserting correctly into the database, I keep getting an error which says undefined index "Notes." Here is the code that I am using for the table form, and also the insert statement...please help!

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO Leads (First_Name, Last_Name, Address, City, `State`, Zip, Phone,   
Email, Fee, Referral_Source, Notes) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
               GetSQLValueString($_POST['First_Name'], "text"),
               GetSQLValueString($_POST['Last_Name'], "text"),
               GetSQLValueString($_POST['Address'], "text"),
               GetSQLValueString($_POST['City'], "text"),
               GetSQLValueString($_POST['State'], "text"),
               GetSQLValueString($_POST['Zip'], "text"),
               GetSQLValueString($_POST['Phone'], "text"),
               GetSQLValueString($_POST['Email'], "text"),
               GetSQLValueString($_POST['Fee'], "int"),
               GetSQLValueString($_POST['Referral_Source'], "text"),
               GetSQLValueString($_POST["Notes"], "text"));

<form action="<?php echo $editFormAction; ?>" method="POST" name="form1" target="_top" id="form1">

<table width="30%%" border="1">
  <td>First Name:</td>
  <td><label for="First_Name"></label>
  <input type="text" name="First_Name" id="First_Name" /></td>
  <td>Last Name:</td>
  <td><label for="Last_Name"></label>
  <input type="text" name="Last_Name" id="Last_Name" /></td>
  <td><label for="Address"></label>
  <input type="text" name="Address" id="Address" /></td>
  <td><label for="City"></label>
  <input type="text" name="City" id="City" /></td>

  <td><label for="Zip"></label>
  <input type="text" name="Zip" id="Zip" /></td>
  <td><label for="Phone"></label>
  <input type="text" name="Phone" id="Phone" /></td>
  <td><label for="Email"></label>
  <input type="text" name="Email" id="Email" /></td>
  <td><label for="Fee"></label>
  <input type="text" name="Fee" id="Fee" /></td>
  <td>Referral Source:</td>
  <td><label for="Referral_Source"></label>
  <input type="text" name="Referral_Source" id="Referral_Source" /></td>
  <td><a href="subform.php?Id=<?php echo $row_Recordset1['Id']; ?>" class="submodal"><img  
  src="Images/editnote.png" class="pencil" width="33" height="33" /></a></td>
  <td><input type="submit" name="Submit" id="Submit" value="Submit" /></td>
<input type="hidden" name="MM_insert" value="form1" />

Edited by pyTony: fixed formatting

6 Years
Discussion Span
Last Post by ananthaninfo

Your form appears not to have an input named "Notes" - that's the index PHP says you're missing, and that might be the problem.


Right, I am not sure how to set that input, since I am using the submodal feature....


I'm sorry, I'm not very well acquainted with the submodal feature. The only thing I can tell you, is that I do not see an input field with the name "Notes" - which is required in your insert query.


Change the line


<td>Notes: <input type="text" name="Notes" id="Notes" /></td>

Good Luck

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.