Im new to databases, and Im not sure what the problem is, so I'll just post what I know.

heres the code, from line 91 - 111, with the error lines in bold (94 and 110)

  $SQL_Exec_String = "Insert Into customers (FirstName, LastName, Address1, Address2, City, State, Zip, Email, LubricantChoice)
            Values ('$FirstName', '$LastName', '$Address1', '$Address2', '$City', '$State', '$Zip', '$Email', '$LubricantChoice')";
 
    $cur= odbc_exec( $cnx, $SQL_Exec_String );
    if (!$cur) {
        Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
    }

    odbc_close( $cnx);
}

$strOldEntries = "Previous Entries in database";
$strNewEntries = "Updated version of databse (after entries)";



HTML_Head();
Database_Entries($strOldEntries);
Output_Entries();
Enter_New_Entry($FirstName,$LastName,$Address1,$Address2,$City,$State,$Zip,$Email,$LubricantChoice);
Database_Entries($strNewEntries);

when i hit submit on the entry page, it displays the old records in my table, and below it, it shows this:

Notice: Undefined variable: FirstName in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: LastName in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: Address1 in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: Address2 in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: City in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: State in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: Zip in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: Email in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Notice: Undefined variable: LubricantChoice in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 110

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Field 'customers.FirstName' cannot be a zero-length string., SQL state S1000 in SQLExecDirect in D:\websites\Sliquid\wwwRoot_Sliquid\html\db\dataac cess.php on line 94
Error in odbc_exec( no cursor returned )


also, it does not add the new record to the database.

It appears that you haven't defined what the variables $firstname, $lname, $address, etc. are. You would need to have a class definition somewhere in your site, as well as a link to that class definition. Also, make sure you assign any variable names to their posted counterparts, for example:

PHP Code:

$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$address = $_POST['address'];
// more definitions 


Then you would need to include the class definition file like this:

PHP Code:

include 'class.php'; 


If you have trouble with class definitions let me know.

that did it

Thanks!!

glad to help

did you end up using a class definition file or did you just declare the variables? speaking of which instead of declaring each of the posted variables manually you could use the following code (i just found this out today):

PHP Code:

while(list($key,$val) = each($_POST) {
$$key = $val;
} 


i suggest you backup your original files before using this code though, as i haven't tried this myself yet, just found out from another talker.