Re: Undefined Index error when trying to insert data from a form into a db

1. Check the manual on use of $_POST and notch down your error reporting level. As these vars have not been defined PHP is throwing an error. 2. While you are at it, and assuming that your variables are all received correctly, why not simplify your sql? insert into test_scores set field_one = '$field_one', field_two = ''$field_two ... and so forth. It makes debugging INFINITELY easier and gives you more control. 3. Not related to your question at all, what's the type of your first field? Does it allow NULL's? If so then default it to NULL. (Something tugging at the back of my mind says that a NULL should not be assignable, but that's another issue.) HTH - Mlies Thompson At 12:53 PM 6/26/2003 -0400, Christopher McCourt wrote:

Hello to all: I am getting the following error message when trying to insert data from an html form into a MYSQL database that I recently created. Can someone take a look at the errors and corresponding code and suggest some alternatives? Thank you very much in advance for your assistance. Regards, Chris McCourt ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++ Error Message: Notice: Undefined index: Store_ID in c:\program files\apache group\apache\htdocs\insertdata.php on line 9 Notice: Undefined index: Postal_Code in c:\program files\apache group\apache\htdocs\insertdata.php on line 14 Notice: Undefined index: Cert_Org in c:\program files\apache group\apache\htdocs\insertdata.php on line 17 Notice: Undefined index: Cert_Level_ID in c:\program files\apache group\apache\htdocs\insertdata.php on line 18 Notice: Undefined index: Cert_Date in c:\program files\apache group\apache\htdocs\insertdata.php on line 19 Notice: Undefined index: Emerg_Contact_Name in c:\program files\apache group\apache\htdocs\insertdata.php on line 20 Notice: Undefined index: Emerg_Contact_Phone in c:\program files\apache group\apache\htdocs\insertdata.php on line 21 Error: Unable to execute insertion query. +++++++++++++++++++++++++++++++++++++++++++++++++++++++ Original PHP Code: <?php /* This page receives and handles the data generated by the form "Insert_Table_Form.html"*/ $Store = ($_POST['Store_ID']); $Users = ($_POST['User_Name']); $Pass = ($_POST['Password']); $Addr = ($_POST['Address']); $State = ($_POST['State']); $Post = ($_POST['Postal_Code']); $Phone = ($_POST['Phone']); $Email = ($_POST['EMail']); $Certor = ($_POST['Cert_Org']); $Certl = ($_POST['Cert_Level_ID']); $Certd = ($_POST['Cert_Date']); $Emergn = ($_POST['Emerg_Contact_Name']); $Emergp = ($_POST['Emerg_Contact_Phone']); //Set the variables for the database access: $Host = "localhost"; $User = "root"; $Password = ""; $Link = mysql_connect($Host, $User, $Password) or die("Could not connect: " . mysql_error()); mysql_select_db('dive_store') or die("could not select database"); $sql = mysql_query("INSERT INTO test_scores VALUES (NULL, '$Store', '$Users', '$Pass', '$Addr', '$State', '$Post', '$Phone', '$Email', '$Certor', '$Certd', '$Certl', '$Emergn', '$Emergp')") or die('Error: Unable to execute insertion query.'); $Result = mysql_query($sql)or die(mysql_error()); if ($Result){ echo("Table Created successfully"); }else{ echo("error when creating table"); } mysql_close($Link); ?>