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”));
| First Name: | |
| Last Name: | |
| Address: | |
| City: | |
| Zip: | |
| Phone: | |
| E-Mail: | |
| Fee: | |
| Referral Source: | |
| Notes: | |